Vlookup person on other sheet, return reference if a date falls between 2 other dates
I need help with the following:
I need to find the contract reference of a person from Sheet 1 in Sheet 2, based on the name of the person and when the mission took place. As you can see below, James had a mission on the 16th of April, so I need the contract reference that corresponds to that date, which would be contract SSA-0009766. Is there a way to do this? I've been working on some formulas but I'm not getting anywhere.
I would really appreciate the help.
Thanks in advance.
Help Article Resources
Check out the Formula Handbook template!