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.