Date range vlookup

[Deventus]

Hi

Need some quick help on a formula, i need a lookup to bring in a field from a separate table, but the lookup will be with a date range.

I need the data required column to have the the fields pulled in from lookup table 2.

any help, as ever, greatly appreciated

thanks
Adi

[gak67]

Something like this?
date lookup.xlsx