VLOOKUP

  • Thread starter Thread starter Weather-Check
  • Start date Start date
W

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.
 
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
 
Back
Top