Forum Discussion
IF function using multiple tabs
How do I get the IF function to locate/compare xxxxx data. The goal is to determine if xxxxx data that is on Tab A is also on Tab D. Any suggestions would be appreciated. Thanks!
Hi,
IF function is inappropriate in this case!
This formula is what you need:
=ISNUMBER(MATCH(B1,$A$1:$A$6,0))
If the text in cell B1 is found in Range (A1:A6), you will get TRUE, if not, you will get FALSE, and so on!
Give it a try!