INDEX & MATCH

[MFM]

I have been using this formula to solve my issuue:

=if(iserror(INDEX($B$1:$E$1,MATCH(B14,INDEX($B$2:$E$11,MATCH(A14,$A$2:$A$11,0),0),0))),0,INDEX($B$1:$E$1,MATCH(B14,INDEX($B$2:$E$11,MATCH(A14,$A$2:$A$11,0),0),0)))

However, for a staff member not listed on a specific date, I would like to
search the next dates down until the staff member is found on a date, then
indicate the department thay worked.

Any help would be appreciated

 

[galimi]

I do not fully understand your challenge, but a custom function could be
written to achieve your purpose.