http://www.mrexcel.com/tip021.shtml

sorry about that forgot to paste the url into it.

"JLeoni" wrote:

Try using the =INDEX - MATCH formula With that you can choose which column
to return the value from - SEE this example
http://support.microsoft.com/kb/214142 or even this one simplifies it even
more

"Antonio" wrote:

Hi to everyone,
I have a document with a table with various columns, and i would need to
search a column which is not the first, to return the corresponding value of
the first column. It would be fine to use vlookup if the column I´m searching
were the first. Is there a function which allows me to choose the column to
search? Or does vlookup has the possibility to search in another column but
the 1st?

Thanks in advance for any help,
Antonio