VLOOKUP

[Weather-Check]

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.

 

[Matt Geare]

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