Forum Discussion
Using Vlookup want the name of person with max salary in east zone
I am having name column first name , last name then region column then salary column.. from this i want the person name who having max salary in east zone with vlookup function.. kindly help me.. ...
If you have Microsoft 365 or Office 2021:
=FILTER(first_name&" "&last_name, (region="East")*(salary=MAXIFS(salary, region, "East")))
In older versions, use
=INDEX(first_name&" "&last_name, MATCH(1, (region="East")*(salary=MAXIFS(salary, region, "East")), 0))