VLOOKUP - Get value from column other than first.

**redinferno** · 03-26-2009, 02:07 PM

I want a value to be searched for in column M and its corresponding value in column A to be returned.

This is the formula I am using:

Please Login or Register  to view this content.

The value 79 is searched for inside column A.

I want it to be searched for inside column M. But since VLOOKUP searches the first argument of the array ( the array specified in the second argument ) I don't know how to do this.

How can I overcome this problem?

Thanks in advance.

**NBVC** · 03-26-2009, 02:11 PM

Try:

=Index(A3:A22,Match(79,M3:M22,0))

**redinferno** · 03-26-2009, 02:19 PM

Thanks NBVC. It worked.

**NBVC** · 03-26-2009, 02:23 PM

Great!

Can you please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save