Index/Match error #N/A

Posted by Anthony on July 31, 2001 11:52 AM

Hello to all! Is there anything wrong with the following array formula:

{=INDEX(A2:B13,MATCH(E2,A2:B13,0),2}

I keep getting the #N/A error.

Any suggestions?

Thanks

Anthony

Posted by IML on July 31, 2001 12:12 PM

Just a guess, but try entering
=INDEX(A2:B13,MATCH(E2,A2:A13,0),2)
no need to array enter it.

This will get you the result in column B next to the result in column A that matches cell E2.

Is that what you are trying to do?

Posted by Aladin Akyurek on July 31, 2001 12:12 PM

Anthony,

As it stands, there is no need to enter it as an array-formula. Moreover, MATCH cannot have a multicolumn range.

INDEX+MATCH is used instead of VLOOKUP in case the value that must be returned is to the left of the lookup column. Is this what you have?

Aladin

Posted by Anthony on August 02, 2001 6:20 AM

That was it!

I had the incorrect range after the Match function. Thanks for the help!

Anthony