Vlookup Question

[AidanDanby]

Hi All,
Is it possible to vlookup to the left of something, ie, 'Vlookup(A3,Sheet1!A:B,-3,false)'

 

[njimack]

Yes, but not with VLOOKUP...
=INDEX(range_to_return,MATCH(lookup_value,lookup_range,0))

 

[mfexcel]

check this out...
Alternative to vlookup – Index and Match | wmfexcel

actually, there are many ways doing that. Try google a bit or search this forum.

Hi All,
Is it possible to vlookup to the left of something, ie, 'Vlookup(A3,Sheet1!A:B,-3,false)'