IF match any

[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.

 

[Chad Portman]

Nevermind I got it.

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

 

[Shane Devenshire]

Hi,

Try this

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

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

 

[T. Valko]

Another one:

=COUNTIF(INDEX(GAT,,1),B2)>0