Help with VLOOKUP Formula

[BizSource]

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

[Lupp]

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

[Lupp]

(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.

[BizSource]

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