Index and Match for first 3 items found, including cells with same values

What you now want is quite complex and requires a different approach, and presentation of results ..

Try this tinker in your example sheet
Input the specified criteria in H2: Jul-12, in H3: Amy, in H4: Dance 5
(You could create and use DV for all of these criteria, to make it easily selectable)

Put this in F2:
=IF(AND(A2=$H$3,TEXT(C2,"mmmyyyy")=TEXT($H$2,"mmmyyyy"),B2=$H$4),ROWS($1:1),"")
Copy down all the way. This flags the criteria specified in H2:H4

Then put this in H7:
=IF(ROWS($1:1)>COUNT($F$2:$F$749),"",INDEX(C$2:C$749,SMALL($F$2:$F$749,ROWS($1:1))))
Copy across to I7, fill down to return all the Dates and Jobs which meet the criteria specified in H2:H4
All results will be neatly packed at the top
(You could easily read off the first 3 or x results)

--------
Success? Celebrate it, hit the star at the bottom left of my responses

That's great, I can definitely use that.

Thanks for all your help Max, Singapore.
Appreciate it!.

welcome, and do take a moment to express your satisfaction by clicking the little star at the bottom left of my responses