IF match any

  • Thread starter Thread starter Chad Portman
  • Start date Start date
C

Chad Portman

I wanna write a formula in column A so that if Column B matches any item in
the named range "GAT" it will return the vaule "TRUE" and if not the vaule
"FALSE". Any ideas.
 
Nevermind I got it.

=IF(ISBLANK(B2)," ",IF(ISNA(VLOOKUP(B2,GAT,1,False),"False","True")
 
Hi,

Try this

=IF(COUNTIF(Gat,B1),TRUE)

This assumes you are checking to see if B1 is in the range Gat.
 
Back
Top