Frequent Contributor

Re: Alternative to LOOKUP with non-composite hierarchies

Hi All, 


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.