VLOOKUP + AND/IF with 3 conditions, using 2 datasets.

[EndeHerc]

Hi All!

I am struggling with a formula where I think I need an Vlookup & AND/IF statements for, but I am not sure.
So this is the situation:

Dataset 1:
Column A: Title
Column B: Date
Column C: Where the Formula should show a Number or UNKNOWN

Dataset 2:
Column A: Title
Column B: Start Date
Column C: End Date
Column D: Number

I want it to work like this: If the title in Dataset 1 matches the title in Dataset 2 AND if the Date from Dataset 1 falls between the start and end date from Dataset 2, I want to show the number (Column D) from dataset 2. If else: show the word 'UNKNOWN'.

I Added two dummy datasets to show what should happen > Dataset 1.xlsx Dataset 2.xlsx (I Accidently added column E & F in dataset 2, please ignore these columns)

Please help !

Thanks.