Xlook to find max value

[hananak]

Dear All,

I am trying to do a look up value formula and my aim is to lookup the names and pick the highest daily rate.

I have a table where I haev list of names of people who worked on different days, same person's name is on this table multiple times but having different daily rates. e.g: Alex has worked on different days and had different daily rates. I have another table where I want to do look up to find Alex and give me the highest daily rate as outcome.

I have tried to use max function within xlookup but not working.

Agency Tracker.xlsx
	H	I	J
10	Table 1
11	Name	Daily Rate
12	Alex	350
13	David	400
14	Nur	500
15	Ruth	600
16	Alex	500
17	David	800
18	Nur	900
19	Ruth	1000
20
21	Result Table - Vlookup		Result I want
22	Name	Daily Rate
23	Alex	350	The Highest Value from above Table
24	David	400	The Highest Value from above Table
25	Nur	500	The Highest Value from above Table
26	Ruth	600	The Highest Value from above Table
Accrual Calculation

Cell Formulas
Range	Formula
I23:I26	I23	=VLOOKUP(H23,$H$12:$I$19,2,0)

Your help would be really appreciated.

 

[Peter_SSs]

@yky
For the future, please be aware of new rule #17 of the Forum Rules

 

[hananak]

Thank you very much everyone for the solutions. This is very helpful.

I have used MAXIF formula in my file.

Cheers.