Alternative to LOOKUP with non-composite hierarchies
I have a list in which there are parent and child relationships defined. Ideally, these should have been created within a composite hierarchy but at this stage I am not considering redesigning the lists.
Is there a function whereby I can reference one of these parent items?
Example - Shoreditch, Westminster, Clapham are parents of London
LOOKUP does not work as it only operates on composite hierarchies.