I need to make a formula that looks up a value and matches it in four different columns. If the value is matched in one of the 4 different tables then return a true or false statement.
I've tried to to do a nested vlookup but I can't seem to make it work beyond one table. I've tried with some AND, OR statements but without success...
Any ideas?
Thanks.
Bookmarks