Originally Posted by
jpgoeth
I am trying to write a formula that will tell me if a value in one cell appears in any of four lists in columns F, H, J, and L. I want it to return "FALSE" if it doesn't match any value in the 4 lists and "Match" if it does. I came up with this:
=IF(ISNA(VLOOKUP(C4,F$4:F$1003,1,FALSE)),IF(ISNA(VLOOKUP(C4,H$4:H$1003,1,FALSE)),IF(ISNA(VLOOKUP(C4,J$4:J$1003,1,FALSE)),IF(ISNA(VLOOKUP(C4,L$4:L$1003,1,FALSE)),FALSE,"Match"))))
But it's not returning the expected result. What am I doing wrong?
Thanks in advance for the help
JP
Bookmarks