Help on large and Matching multiple columns

[mnsportsfan]

I'm looking for formulas in cells S3 to S6 that will return the largest number from the week set in cell S12. After it finds the largest numbers I'd like to return he employee name from column A into cells R3 to R6 matching the numbers in S3 to S6.

[wk9128]

Cell R3 formula , Drag down

Please Login or Register  to view this content.

Cell S3 formula , Drag down

Please Login or Register  to view this content.