If date from table is within date range, then return value from other table

[DipDip]

Hi All,
I'm racking my brain on how to do this, but can't seem to find the answer. I'm really hoping someone can help me. I have a worksheet with a table that looks like the below:

A	B	C	D	E	F
Date	Label 1	Label 2	Label 3	Label 4	Label 5
01/02/24	123
02/02/24		105
02/02/24			100
16/02/24					251
10/02/24				500

I then have another table on the same worksheet that looks like this:

P	Q	R	S	T
	01/02/24	05/02/24	12/02/24	26/02/24
	04/02/24	11/02/24	18/02/24	29/02/24
Label 1	Q3	R3
Label 2	Q4	R4
Label 3	Q5	R5
Label 4	Q6	R6
Label 5	Q7	R7

What I want to achieve is that in Cell Q3, it returns 123. It looks up all the data in the first table, and if the date is within the range the date range above it, and also from Label 1, then it returns the value. There will never be more than one entry per Label per date range. But there could be repeats of the date, but with entries for other Labels. The dates also may not be in order of oldest to newest.

It would then look like the following if it worked:

P	Q	R	S	T
	01/02/24	05/02/24	12/02/24	26/02/24
	04/02/24	11/02/24	18/02/24	29/02/24
Label 1	123
Label 2	105
Label 3	100
Label 4		500
Label 5			251

Thanks in advance for any help or pointers people can give me.

Dipam

 

[DipDip]

I've entered this into Q3:

{=INDEX(B$2:B$58,MATCH(1,IF($A2>=$V$3:$V$7,IF($A2<=$W$3:$W$7,1)),0))}

And it worked for that first box but won't work for the others.

To the side I've added the dates so they are re-arranged in a better way. Hence V & W.

	01/02/2024​	05/02/2024​	12/02/2024​	19/02/2024​	26/02/2024​
	04/02/2024​	11/02/2024​	18/02/2024​	25/02/2024​	29/02/2024​
Label 1	123​					01/02/2024​	04/02/2024​
Label 2						05/02/2024​	11/02/2024​
Label 3	#N/A​	#N/A​	#N/A​	#N/A​	#N/A​	12/02/2024​	18/02/2024​
Label 4	#N/A​	#N/A​	#N/A​	#N/A​	#N/A​	19/02/2024​	25/02/2024​
Label 5	#N/A​	#N/A​	#N/A​	#N/A​	#N/A​	26/02/2024​	29/02/2024​

 

[DipDip]

Anyone please? Or at least help point me in the right direction so I can research and do it myself.