I'm trying to implement a series of cascading/dynamic drop down lists (once var1 is selected, only unique relevent options should be displayed for var2, then var3 options should depend on var1&var2, etc....), which once all selected display data in the output section.
If I enter the input data manually the correct data is displayed. It is the dropdown lists I'm having problems with (using DGET for this).
I found this thread and tried to follow it by adapting it to my spreadsheet with not much success so far:
I've attached a sample of my attempt with the integrated code taken from the link above. The data on "master" is close to what I'm really going to use (ie several spaces and illegal characters used). Each row on master sheet has a unique set of variables.
Thanks for the help.