Hi guys,

I'm working on on something that obtains a value from a data set with numerous columns and rows, where the columns are the entities, and the rows are the account codes.
I am trying to formulate a formula that will obtain the values for a given entity and a given cell that will identify multiple account codes based on a mapping.

I have three sheets:
- Mapping: a table that includes the account codes I need for a given description, for example, "fixed costs" includes 1.5,1.6,1.7
- Data: these are the income statements for each entity next to each other
- Analysis: I need the to establish a formula that will obtain the value(s) for a given description, from a given entity. For example, the fixed costs (accounts 1.5,1.6,1.7) for entity 3.

I have attached in what form my data comes, I cannot find out how to formulate the formula,

I currently have a mix of SUMPRODUCT(SUMIFS(XXX; INDEX; MATCH), but it doesn't quite work...

Any ideas? Attached is an example sheet.
Example sheet.xlsx


Best,
Jovanni