display the name in a list with the maximun salary
 

I try to display the name in a list with a mximun salary, but the names are
in A1:A50 and salaries in B1:B50. Can I use Vlookup and Max?

display the name in a list with the maximun salary
 

=INDEX(A1:A50,MATCH(MAX(B1:B50),B1:B50,0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"cyber" wrote in message ...
|I try to display the name in a list with a mximun salary, but the names are
| in A1:A50 and salaries in B1:B50. Can I use Vlookup and Max?

display the name in a list with the maximun salary
 

Hi Cyber,

I suppose you want the name with the biggest salary:
I created my function in the dutch version of Excel giving:

=VERSCHUIVING(A1;VERGELIJKEN(MAX(B:B);B:B;0)-1;0)

and tried to translate it...

=OFFSET(A1,MATCH(MAX(B:B),B:B,0)-1,0)


HTH,

RaderEye.