Re: Alternative to LOOKUP with non-composite hierarchies
I appreciate all your efforts to help. The solutions provided while appearing to offer a solution are all too lengthy and cumbersome where this can be resolved by redesigning the lists and removing the list subtotals.
As this is a client model in which I have not been the principle model builder this will be my suggestion to the model team.
Chris Heathcote Bedford Consulting
Gold Partner and Regional Partner of the Year 2021, EMEA