Functions

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
=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
 
Back
Top