ExcelBanter - VLOOKUP

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/257677-vlookup.html)

Okay I have figured out how to do a VLOOKUP in a column of some 250 entries
and it returns the highest value in the column, however I would also like to
have it return the numbers in the column to the left of the highest value
found by the VLOOKUP.

Hi,

I suspect you will need to use INDEX and MATCH functions together, as a
VLOOKUP cannot do what you want.

Have a look at this to see the technique:

http://www.contextures.com/xlFunctions03.html

Look at the "INDEX / MATCH -- Example" for starters.

It's a little bit mind bending the first time you look at it but the last
two sentences in this paragraph I have referenced explain the two separate
steps well.

Cheers,

Matt

"Weather-Check" wrote:

Okay I have figured out how to do a VLOOKUP in a column of some 250 entries
and it returns the highest value in the column, however I would also like to
have it return the numbers in the column to the left of the highest value
found by the VLOOKUP.