VLookup
 

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

VLookup
 

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)

In article ,
JAD wrote:

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