G Guest Oct 18, 2006 #1 I need to display the name in a list with the maximun salary. What function I need?
D dolivastro Oct 18, 2006 #2 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
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
S smw226 via OfficeKB.com Oct 18, 2006 #3 =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
=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