Lookup several elements from a table updated each month

[Charlie98]

Hello to the community,

I've been browsing here now and then but this is the first time I'm posting :-)
So here is my issue, I have been wondering for a long time if there was a smart and easy way to do that - maybe one of you can help me ?

Let's say I have a table of raw data with about 10 lines and 10 columns.
This table is updated every month with new data but the same format.
On another tab, I have each month in a different column, several lines
I want for each column/month and each line to look for the corresponding data in the raw data table.

What I have tried : pasting the table for each month below the one for the previous month with adding "Month" column. I was thinking about using the Vlookup function however I can look for only one attribute and here I need to look for several ones (the right month, then the right line/metric, then the right column/segment).
I also thought using a pivot table with the month as filter but then I'm not sure how to look in the pivot table with a specific filter/month...

I attached a sample file so it's maybe more clear what I'm trying to do - basically to fill the different cells on the "Table" tab without having to link them one by one for each month.
Is there a smart way to do this ?

Many thanks !

[Pete_UK]

You can use this array* formula in C3:

=SUM(INDEX(Raw_Data!$E$2:$F$19,MATCH(1,(Raw_Data!$A$2:$A$19=C$1)*(Raw_Data!$B$2:$B$19=$B3),0),0))

*Note that an array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual Enter.

You might also need to use semicolons ( ; ) instead of commas ( , ) in your formula, depending on your regional settings.

Then you can copy this across and down as required for Segments 3 and 4. For other segments, you will need to change the range reference shown in red in the formula (e.g. for Segments 1 and 2 this would become $C$2:$D$19 ), as there is no direct match between what you have in column A of the Table sheet and the headings on row 1 of the Raw_data sheet. Don't forget to use CSE again if you edit the formula.

Hope this helps.

Pete