Functions

[Guest]

I need to display the name in a list with the maximun salary. What function
I need?

 

[dolivastro]

I assume that the salaries appear in the range A1:A15, and the names
appear in B1:B15. Then use this:

=VLOOKUP(MAX(A1:A15), A1:B15,2)

Hope this helps,
Dom

 

[smw226 via OfficeKB.com]

=VLOOKUP(MAX($A$1:$A$19),$A$1:$B$19,2,FALSE)

You will have to ensure that the salaries are to the left of the names.

A1:A19 is the list of salaries


HTH

Thanks,

Simon