VLOOKUP help needed

[jondon]

I am using a VLOOKUP formula in columns C thru F in hopes that it will pull information from the cell in columns K thru O when data is entered in column A. It works with the exception that if the data inserted in A is not listed in K - O the cells will still populate from what appears to be the closest match. Forum help 2.xls

I hope the sheet can better explain my desired results.

[Fotis1991]

Try in C3.

=IFERROR(INDEX(L$4:L$171,MATCH($A3,$K$4:$K$71,0)),"")

Copy down and across.

Edit: For Excel 2003, use this one.

=IF(ISERROR(INDEX(L$4:L$171,MATCH($A3;$K$4:$K$71,0))),"",INDEX(L$4:L$171,MATCH($A3,$K$4:$K$71,0)))

[jondon]

I got this after dragging down.


MLS5582 #NAME? #NAME? #NAME? #NAME?
LTD5572 #NAME? test126 test226 test326
MLB8583 #NAME? test137 test237 test337

[jondon]

I should mention I use Excel 2003.

[Fotis1991]

See my edit in post2. You use Excel 2003 and IFERROR does not work .

[jondon]

Excel said if found an error and change it to...
=IF(ISERROR(INDEX(L$4:L$171,MATCH($A3:$K$4:$K$71,0))),"",INDEX(L$4:L$171,MATCH($A3,$K$4:$K$71,0)))

But then it said, that was a circular reference.

[Pete_UK]

There is a colon between $A3 and $K$4 in the first MATCH expression - change this to a comma.

Hope this helps.

Pete

[Fotis1991]

Take a look here.

Edit:Thanks Pete

[jondon]

Yes.. It works... Thank you very much. I will mark as solved, as soon as remember how.

[Fotis1991]

You are welcome.

Thanks for the reb*