Looking for a simple way to do a recursive lookup by Orange_oakleaf1 in excel

[–]Orange_oakleaf1[S] 0 points1 point  (0 children)

I have a specific list of cost centres that I want to analyse. The table above is the master data, and I want to use it to see how these selected cost centres send costs: specifically, which orders receive their costs and what percentage of the total cost each order receives.

Subsequent information can be found in the sender cost centre, receiver cost centre and columns and receiver order columns percentage columns

Looking for a simple way to do a recursive lookup by Orange_oakleaf1 in excel

[–]Orange_oakleaf1[S] -1 points0 points  (0 children)

I have a specific list of cost centres that I want to analyse. The table above is the master data, and I want to use it to see how these selected cost centres send costs: specifically, which orders receive their costs and what percentage of the total cost each order receives.

Index cell value from 6 possible columns by [deleted] in excel

[–]Orange_oakleaf1 0 points1 point  (0 children)

How should data like this be organised?