index and match with different column location

Here's one construct which delivers the results ..

As all Holes data in the 10 cols C to L need to be checked for the value in O4
Put in S4: =INDEX($A:$A,MATCH($O4,C:C,0))
Put in S5: =INDEX($B:$B,MATCH($O4,C:C,0))
Copy S4:S5 across by 10 cols to AB4:AB5

Then you could use these to gather the desired results
In P4, normal ENTER will do: =INDEX(S4:AB4,MATCH(TRUE,INDEX(S4:AB4<>"N/A",),0))
In P5, normal ENTER will do: =INDEX(S5:AB5,MATCH(TRUE,INDEX(S5:AB5<>"N/A",),0))
Format P4 as date

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

Given that:

A2:A31 houses dates, B2:B31 either day or night shift states, C2:L31 the occurrences of the lookup value, and O4 116650 which is the lookup value of interest:

P4, control+shift+enter, not just enter:

=INDEX(A2:A31,MIN(IF(C2:L31=O4,ROW(C2:L31)-ROW(C2)+1)))

Q4, control+shift+enter, not just enter:

=INDEX(B2:B31,MIN(IF(C2:L31=O4,ROW(C2:L31)-ROW(C2)+1)))

Thank you so much Aladin Akurek, thank you also Max Singapore, both works and i just choose the simplier one