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










--
A36B58K641