Using Vlookup want the name of person with max salary in east zone

[Shubham2207]

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..

Note* name column are seperate like siri and adam and i want that name together siri adam.

[#2]

@Shubham2207 

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))