Return corresponding name of max value

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Agree that we need to see a sample workbook, not a pic

Having said that, you probably want something like...
=INDEX(P:P,match(MAX(Z:Z),Z:Z,0))

Not quite clearly with Last Buyer Name, but try

=IF(B2=K2,A2,LOOKUP(2,1/(B2:J2=K2),$B$1:$J$1))

Q2:Y2=Z2 returns TRUE where meets condition/FALSE where dont.
1/(Q2:Y2=Z2) converts TRUE to 1 and FALSE to #DIV/0
i.e {#DIV/0,#DIV/0,1,#DIV/0,#DIV/0}

Lookup value 2 (or any value that >1) will look for 1 then returns corresponding value in Q1:Y1

Hope it is clear for you.

Here is another way of making the same calculation:

Formula:

Please Login or Register  to view this content.

Thank you for the feedback.

Oops ..... duplicated message. Please delete.

Originally Posted by johnelder

This is very clear to me now, except I still do not understand how the lookup value must be >= 1... I see that if the value is <1, for example 0.5, it does not return the name if the highest offer belongs to someone in the columns R:Y.. but i do not understand the microsoft article on on the lookup function is not very helpful either

LOOKUP syntax:

=LOOKUP(Value, ascending_range,[lookup_range])

Asending range, ie:

{0,1,2,3,...}

{" "," ",1," "}

{#DIV/0,#DIV/0,1,#DIV/0,#DIV/0}

but not :{0,0,1,0,0}

in our sample file:

=LOOKUP(any value greater than 1,{#DIV/0,#DIV/0,1,#DIV/0,#DIV/0},{"Jenny","Pete","Jack","ABC","XYZ"}) = Jack

More example for lookup value:

=LOOKUP(3,{0,1,2,3,5,6},{100,50,3,40,9,5}) =40


=LOOKUP(4,{0,1,2,3,5,6},{100,50,3,40,9,5}) =40