Vlookup Max Value

[hscott82]

Hello, I am trying to look up the Max Value (Paid Rate) from one sheet and return it to another sheet.

I have employees that are paid at a Base Rate, but sometimes are paid at a different rate. On 'Orig' Tab there can be a lot of Rows for employees and I need to find the MAX Paid Rate in Column P. It would be Higher than their Base Rate.

Sheet 1 (Research Tab)

B	C	I	K
Employee ID	Name	Base	Paid rate
0238324	Smith, John	$ 20.00
0502199	Toms, Alex	$ 9.75
0445882	Walters, Jean	$15.00

Sheet 2 (Orig Tab) The Paid Rates in RED are the Values I am looking at Returning to the Research Tab, because they are different than the Base Rate in column H.

C	D	H	N	P
EMPLOYEE ID	Name	Base Rate	Code	Paid Rate
0238324	Smith, John	20​	REG2	20​
0238324	Smith, John	20​	REG2	25​
0238324	Smith, John	20​	REG2	20​
0502199	Toms, Alex	9.75​	REG2	9.75​
0502199	Toms, Alex	9.75​	REG2	10.5​
0502199	Toms, Alex	9.75​	REG2	9.75​
0445882	Walters, Jean	15​	REG2	15​
0445882	Walters, Jean	15​	REG2	15​

 

[hscott82]

GRIN...
So, for Smith, you want 005 and for Toms, you want 130?!

What happens when someone works non-home and the same number of hours at each of the non-home locations?
Did you think of that one?

That would be very hard to have happen. Our system doesn't "Round" their hours so the chances of them ever working the exact same amount of hours is extremely slim.

 

[kweaver]

Did my last shot work?