INDEX MATCH MATCH? VLOOKUP? XLOOPUP? Please help :)

Hello,

I am trying to do what I had believed was a VLookup however the lookup needs to match the criteria of a date range.

If it was a simple vlookup,

value: Vessel Name
table array: 'MASTER'!A1:H30
col_index_num: 3 (i.e. the ID Number)
and range: 0

But the complication arises as the match needs to be added so the right ID number corresponding to the date is indexed i.e. the PSC Date needs to fall between the Start and End dates for it to return the correct ID number.

Thanks!

efWGWSVARGED.png