Hey all, been struggling with a tricky problem and google doesn't seem to be helping.

Basically I want to take the top five most important goals as from one table, but only ones that meet the requirement "Mine"

The table is setup on the worksheet Goals as follows
Colum B stores the goals
Colum C the priority of the goal (1-5) so it needs to be okay with duplicates
Colum F who the goal belongs to (Mine or others)

The table its transferring to is on another sheet and has the following formula stored in C3
=IFERROR(INDEX(Goals!$B$2:$B$100,MATCH(1,INDEX((Goals!$C$2:$C$100=LARGE(Goals!$C$2:$C$100,ROWS(C$5:C5)))*(COUNTIF(C$5:C5,Goals!$B$2:$B$100)=0),),0)),"")

This works just fine to get me the top five values, I just don’t know how to make it based on criteria from colum F

Any help would be very gratefully received