Another one:

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

--
Biff
Microsoft Excel MVP


"Chad Portman" wrote in message
...
Nevermind I got it.

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

"Chad Portman" wrote:

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.