if formula

[nisselyo]

How do I check an array. meaning if A1 = b1, b2, or b3 then do X if not do y, as oposed to doing =if(or(a1=b1, a1=b2,a1=b3...)
Thanks

 

[MrKowz]

Try:

=IF(ISNUMERIC(MATCH(A1,B1:B3,0)),*do x*,*do y*)

 

[nisselyo]

thanks but my a1 is not a number its alpha. I cant get it to work?

 

[MrKowz]

Can you please provide a sample of your data?

 

[nisselyo]

if bgK4 = conteent of cell b1, b2,b3

 

[Scott Huish]

The contents of your cell A1 is not what the ISNUMERIC is referring to, although it should be ISNUMBER It is checking to see if MATCH returned a number.

=IF(ISNUMBER(MATCH(A1,B1:B3,0)),"do x","do y")

 

[nisselyo]

I did but couldnt get it to work - ill try again

 

[T. Valko]

Try:

=IF(ISNUMERIC(MATCH(A1,B1:B3,0)),*do x*,*do y*)

ISNUMERIC is VBA.

You probably meant ISNUMBER:

=IF(ISNUMBER...

 

[MrKowz]

ISNUMERIC is VBA.

You probably meant ISNUMBER:

=IF(ISNUMBER...

Friday Brain Fry strikes again - thanks for catching that!

 

[Scott Huish]

Excel Workbook
	A	B	C	D	E
1	ABC	DEF			do x
2		ABC
3		XYZ
Sheet1