Excel 2002: Can Vlookup search at left hand side of the table?


G

Guest

Dear Sir,

Is there a way to lookup for data at the left hand side of the search value?

I try using =VLOOKUP (A1,C$20:D22,-2,FALSE) as illustrated below, but it
does not work.

A B
Lookup value Data (Answer)
1 ND000236 =VLOOKUP (A1,C$20:D$22,-2,FALSE) Answer : PKHLK050
2 ND000237


Look up table

A B C D
20 PKHLK050 05/04/2007 ND000236 (155.00)
21 PKHLB390 18/04/2007 ND000237 200.00
22 PKHLT041 18/04/2007 ND000238 50.00

Is there any other formulas for this function , other than relocating column
A at the right hand side of column C and applying the formula in the usual
way ? (i.e. column index number must be >= 1)


Thanks


Low
 
Ad

Advertisements

G

Guest

Think it's easier to use INDEX/MATCH here ..

Try in B1:
=INDEX($A$20:$A$22,MATCH(A1,$C$20:$C$22,0))
Copy down
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top