Thread: display the name in a list with the maximun salary
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default 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?


Reply With QuoteReply With Quote