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:
I then have another table on the same worksheet that looks like this:
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:
Thanks in advance for any help or pointers people can give me.
Dipam
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