Help with VLOOKUP Formula

Peace my friends. I am trying to use a function like VLOOKUP to return the value from a small range of data corresponding to the MAX value in one of the columns.

The VLOOKUP formula I entered is not returning the value I am looking for, here is a link to the spreadsheet at Excel Online if anyone has a quick minute to look it over.

Many thanks :slight_smile:

Posting questions as wikis doesn’t make much sense. It’s your question after all.

(Really funny that Excel toy.)

Did you mean =INDEX(A2:A8,MATCH(C11,G2:G8,0))?
With VLOOKUP() you can only select fields (columns) to the right of the column where the match must be found.

Brilliant that solved the issue. Many thanks and blessings to you!