Index and match based off of top 5 list for a specific field in a filtered column

[ScottBeatty]

So I have myself in a bit of a situation as you can tell by the title. I want to be able to find the corresponding employee to an absolute value of a difference for a specific client.

To find the largest difference, I used (for client 1, for example):
=LARGE(IF(A:A="Client 1", ABS (B:B), ""), 1)

I attached a sample, simplified spreadsheet due to my lack of being able to describe what I want. I also typed in the yellow shaded cell my equation that I tried and it did not work. I highlighted in green the values I expect to get but I am having a tough time. My boss is already using a pivot table on the real spreadsheet I am working with but he wanted a sheet with visuals that can be easily read without any additional effort. Any help would be great!!

(I realize I made a mistake for the "biggest difference" equation for "client 2" by using "client 1" instead. I just fixed it and got the value of 12 when I was expecting a name of one of the employees.)

-Scott

[Ace_XL]

In G6

=INDEX(C:C,MATCH(1,(A:A=E6)*(ABS(B:B)=F6),0))

Array entered

[ScottBeatty]

Oh awesome, so for future knowledge, why did you used "1" for the first portion of the MATCH equation?

[Ace_XL]

using the binary equivalent, TRUE eqautes to 1 and FALSE equates to 0.

Only, if both conditions are TRUE [(A:A=E6) and (ABS(B:B)=F6)] (which is what you want!) will their multiplication result in 1. Using that as a premise, the MATCH function is formulated.

[ScottBeatty]

Oh I follow that. Thanks a lot!