IF match any
 

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.

IF match any
 

Hi,

Try this

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

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


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

IF match any
 

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.

IF match any
 

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.