VLookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table in which the lookup values is not in the first column but a
couple of columns to the right of the tables first column of data. I seem to
recall, but have forgotten if true, that you can have the lookup value column
anywhere by using negative column index numbers to find data that is to the
left of the lookup value column. For values to the right of the lookup
column, you would use positive values. To further clarify what i am trying to
accomplish, please refer your response to the following application.

Application: An Excel tabel that starts in column B and ends in column M.
The lookup value is in column D. We want to retrieve data from any of the
colums from B thru M.

Any help would be greatly appreciated. Thank You, JAD
 
Use

=INDEX(B:M,MATCH(y,D:D,FALSE), x)

where y is your lookup value, and x is your column number (e.g., B=1)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and retrieve values 1 row below the normally retrieved val 2
Vlookup array formula problem 2
Vlookup and get the maximum value 4
Scrabble Value calculation for Welsh words 0
Using ISNA on more than one column within an If Function 2
vlookup or index? 0
Adding up total hours worked on employee schedule using various criteria 0
With F1 value, look at A, if match or partial match return B 5

Back
Top