index match not working

[chriswrcg]

I can't figure out why this formula in Q1 is not working.

[Fluff13]

It's because you have #N/A errors in col C, try this instead

=IFERROR(INDEX('Punch Log'!$F$2:$F$463,AGGREGATE(15,6,(ROW('Punch Log'!$F$2:$F$463)-ROW('Punch Log'!$F$2)+1)/('Punch Log'!$C$2:$C$463=P1)/('Punch Log'!$D$2:$D$463=O1),ROWS($Q$1:$Q$1))),"")

[chriswrcg]

Thank you Fluff13

[Fluff13]

Glad to help & thanks for the feedback.

[Bo_Ry]

If you only want the first one, please try

=INDEX($F$2:$F$463,MATCH(1,('Punch Log'!$C$2:$C$463=P1)*('Punch Log'!$D$2:$D$463=O1),))