Col B has a Dynamic list of Categories.
Col D has a Dynamic List of elements for the first Category ("Physical and organoleptic requirements").
I can select the Category from the DropList in G2, which should then populate the Dependent DropList in G4.
Because there are multiple spaces in the Category Name I know normal "Indirect(Substitute" won't work
Tried the following formula in G4, but doesn't work either:
=INDIRECT(SUBSTITUTE(SUBSTITUTE(G2," ","")))
All solutions, suggestions and pointers welcomed as ever
Ochimus
Bookmarks