Need to get formula to work IF,(Index(Match(Large

[studentpro]

I am having trouble trying to get this formula to work. In the workbook I have a scorecard table(sheet 1 & its not a pivot table) that pulls in the information from raw data(sheet 2). I want to return the top 5 contract #'s based on the top five highest priority level and contract owner name.

[Sheet 2] [column] owner priority level contract #
[Row] [A] [C]
1 Julie 1 006663
2 Sara 6 145111
3 Jon 3 822222
4 Steve 4 999999
5 Juli 7 888889
6 Steve 6 223232
7 Juli 3 111111
8 Jon 2
9 Sara 1
10 Juli 1

So in sheet 1 if we were looking at Juli and returning #1 priority- the if function would match "Juli"_large function "7" and the value returned with index(match "888889"

 

[studentpro]

Or if someone has a better formula that would work, that would be great.