HELP: EXCEL function Index & Match with 3 criteria, Reward given

[Lunardragon]

Hello,

I am having a difficulty to apply Index and match excel function (with 3 criteria) on my worksheet.

Could someone help me please? send me a pm if you could.

I will send out 1x 1oz Kook PM silver coin (mint) as to say thank you if you could resolve this puzzle.

thank you.


LD

 

[Lunarowl]

How did you manage to fit 3 dimensional data into a worksheet to start with?

 

[Lunardragon]

Thank you all.
Finally it resolved.

LO,
The raw excel data from the system being the database.
Then need to feed the workbook with using on a cost centre, income category and date as criteria. The formula is very looooong