How to create IF Formula between 2 table

[Yayasan_TL_BP]

I have 2 table

• pcr table
• lpj table

i want to create formula on pcr table in column status_pcr, with lpj table in column status_lpj as reference, i use IF formula in column status_pcr = IF((lpj,[status_lpj])=“Open”,“Open”,“Closed”), but the formula doesn’t work.

How to create right formula between table?

Need your help