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

Please Login or Register  to view this content.

[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),))