VLOOKUP in a Range of Dates?

[SAMCRO2014]

I don't even know if a macro can help me with this. I have a listing of employees showing their annual pay rates by a range of dates. I need to be able to look up a date within those ranges. For example:

Employee # Start Date End Date Annual Salary

Employee 123 2018.04.01 2018.06.15 $50,000
Employee 123 2018.06.16 2018.10.31 $53,000
Employee 123 2018.11.01 2019.03.31 $57,000

I need to be able to find the Annual salary for the date of 2018.08.01 and 2019.02.03 for overtime worked that day.

This is a simplified example. There are several employee numbers who all have different start and end dates.

Can a macro help me do this? I have no idea where to even start.

 

[Trevor G]

take a look at SUMPRODUCT. If you can work it through great if not copy some data (Remove names) showing which columns etc your using.

 

[SAMCRO2014]

Thanks! This gives me a starting point