Index Match Help

[Blueorangez]

I have 2 sheets


Export (Contains a table)
Sheet4 (Contains a range of data)

on Export I have an ID ref number in column D.

This ID refers to a person on Sheet4 with multiple job start dates

back on the Export tab, I also have a shift date in column M ([@Shift_Date])


I want to look up that particular person using the ID ref called [@PID_PAN]
Then return the first value on Sheet4 in column R where the shift date is greater than the Job Start Date

The highlighted date is the value that should be returned for this person with the shift date 31/08/21


hope someone can help

Thanks