

MAX, MATCH, VLOOKUP
AND LARGE

We
have the salray data of the employees in a company and wish to find
the highest salary, the name of the person drawing the highest salary
and also wish to know who draws the third largest salary. There are
many ways to accomplish this in Excel but let's see how we can achieve
our goal using simple formulas involving 'MAX', 'MATCH' 'VLOOKUP' an
the 'LARGE' functions.

Before using the above functions we name the range A1::C11 as 'mydata' and the range C3:C11 as 'salary'. Now we use the above functions appropriately as shown in the Excel training video below:
