Can vlookup for the value in left?

[isaackoh]

Normally we using vlookup for the value in the right side.. i trying to get the value from the left.. any suggestion?

[MarvinP]

Hi Isaac,

If you need to look to the left in a table of numbers, you need to use the Index Match construct instead of VLookup. You are correct that VLookup will only look to the right.

http://exceluser.com/formulas/excels...-functions.htm tells more.

[martindwilson]

use either index /match or vlookup like this =VLOOKUP(A1,CHOOSE({1,2},C1:C10,B1:B10),2,FALSE) which will look in c and return from b
index match would be
=index(b1:b10,match(a1,c1:c10,0))

[isaackoh]

use either index /match or vlookup like this =VLOOKUP(A1,CHOOSE({1,2},C1:C10,B1:B10),2,FALSE) which will look in c and return from b
index match would be
=index(b1:b10,match(a1,c1:c10,0))

Martin, if my column C have several cell with the same value, may i call all the B cell value with the same C value?

[FDibbins]

vlookup and index/match will only return the 1st match they find, and then stop looking

[isaackoh]

Martin, if my column C have several cell with the same value, may i call all the B cell value with the same C value?

Any vba code to help?

[FDibbins]

A formula will do this for you, upload a sample workbook