Ask Your Question
0

Help with VLOOKUP Formula [closed]

asked 2018-03-16 22:55:54 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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 :)

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by BizSource
close date 2018-03-16 23:31:50.959902

Comments

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

Lupp gravatar imageLupp ( 2018-03-16 23:14:50 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-16 23:13:48 +0100

Lupp gravatar image

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

edit flag offensive delete link more

Comments

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

BizSource gravatar imageBizSource ( 2018-03-16 23:18:39 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2018-03-16 22:55:54 +0100

Seen: 101 times

Last updated: Mar 16 '18