VLOOKUP to the left

[renatoabc]

By default, in Excel 2010, the vlookup function return values from columns that are at the right of the table.


I know there is a way to make it possible to look for data in columns at the left also, but I'm not sure how.


Sometime ago I saw something like "indirect", but I have no idea how to build the formula.


Any help is great welcome.

 

[NARAYANK991]

Hi ,


The following link explains it well. If you have any more questions , please ask.


http://www.mrexcel.com/articles/excel-vlookup-index-match.php


Narayan

 

[oldchippy]

Hi,


Here's another link here


http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/