How to create IF Formula between 2 table

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

Can you give more information, such as the snapshot of both tables, what it the relation between the two tables, and where do you want to put this formula?