Help with VLOOKUP + DMAX

[DarCady]

Hello,

I am trying to use the VLOOKUP and DMAX functions to return two values. In brief:

There is a table with two coulmns, Participant and Earnings, with names listed under Participant and dollars under Earnings. I am trying to write a function that creates a sentence that reads "This week's top earner is " top earner " with " earnings. I have properly written the DMAX function to find and return the proper amount under the earnings column, but cannot figure out how to get it to look up and return the appropriate name. The properly written DMAX function reads:

DMAX(B78:E90,"EARNINGS",E78:E90)

wherein B is the participant column and E is the earnings. How do I write a function that says "X" is the person with those earnings?

Thank you in advance for your reply.

[NBVC]

Do you mean?

=Index(B78:B90,Match(DMAX(B78:E90,"EARNINGS",E78:E90),E78:E90,0))

[DarCady]

That seems to have solved it, thank you!