VLOOKUP + IF formula???

I'm fairly inexperienced with advanced excel functions, so this might be a ridiculously simple problem to solve. But I have 2 worksheets and I need to populate data in one worksheet based on information found in the second. Worksheet 2 has multiple row entries for the same person, but I'm looking for the row with the total amount.

So, I need a formula that will match the name from both worksheets, and populate '384.60' into worksheet 1 under the Employee Total column and '1,230.76' under the Employer Total column.Not sure what formula to use, but I'm thinking a combination of Vlookup + IF?

Thanks for the suggestion... my actual spreadsheet is a little more complicated. Sorry I should have specified instead of trying to simplify it. In sheet 1, I need to populate EMPLOYER TOTAL in column H and EMPLOYEE TOTAL in column I (and the column headers are different). In sheet 2, the four columns are C,D, E and F.

Oh, and FYI, I managed to populate column H using this formula... by searching for the name in sheet 1, column A and pulling the largest value in sheet 2, column E:

The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.