Remove #N/A in match

[rspalding]

Hello,

I'm using the formula =MATCH($L$1,$E2:$J2,0) How do I get rid on the N/A. I've tried just about everything I can think of. I'm using 2010 Excel.

Thanks for the help!

 

[jtakw]

Hi,

How about:

=IFERROR(MATCH($L$1,$E2:$J2,0),"")

 

[rspalding]

Works perfect. Can it return L1 instead of the position?

Thank you!

 

[Aladin Akyurek]

Try...

=IF(ISNUMBER(MATCH($L$1,$E2:$J2,0),$L$1,"")

The ISNUMBER test is faster than the IFERROR test.

 

[rlv01]

If you want it to be specific to the #N/A error

=IF(ISNA(MATCH($L$1,$E2:$J2,0)),"",MATCH($L$1,$E2:$J2,0))

 

[Aladin Akyurek]

A closing paren is missing:

=IF(ISNUMBER(MATCH($L$1,$E2:$J2,0)),$L$1,"")

 

[rspalding]

Works perfect.

THANKS.....

 

[Aladin Akyurek]

Works perfect.

THANKS.....

You are welcome.