Possible ?-->IF(C1 Resident T1 = C2 Resident T2, ......) As

[robert_mika]

As in subject can you reference two tables in IF statement?

I have seen similar approach with ApplyMap.

[Gysbert_Wassenaar]

Perhaps the LookUp function is what you're looking for. If not, you'll probably have to join the two tables first so you can compare the fields.