vlookup

[John]

VLOOKUP returns a result to the right a given number of columns from the search column. Is there a way to do a lookup that returns the result by looking to the left of the search column?

 

[Chip Pearson]

John,

See the Left Lookups section at www.cpearson.com/excel/lookups.htm .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]

VLOOKUP returns a result to the right a given number of columns from the

search column. Is there a way to do a lookup that returns the result by
looking to the left of the search column?