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$2022,-2,FALSE) as illustrated below, but it
does not work.
A B
Lookup value Data (Answer)
1 ND000236 =VLOOKUP (A1,C$20$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
Is there a way to lookup for data at the left hand side of the search value?
I try using =VLOOKUP (A1,C$2022,-2,FALSE) as illustrated below, but it
does not work.
A B
Lookup value Data (Answer)
1 ND000236 =VLOOKUP (A1,C$20$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