Hello All,
I am trying to write a formula where I need to check if value exists in multiple columns.
I tried below formula. It gives me #NA even if the value exists in Col B. I need the check to be done in columns A,B and C. If the value exists in any of the 3 columns my result should be 0 else 1.
=IF(ISTEXT(VLOOKUP([@Account],Accounts!$A$2:$C12,1,0)),0,1)
Thanks in advance
Bookmarks