Forum Discussion
calling an entire table, depending on the dropdown lists selected.
I'm trying to create something for my place of work, but have hit a slight problem, and have been racking my brain for hours now, but im very out of practise with Excel and hoping someone can help. ...
The obvious way to do this might be to create a 4 column lookup table. First 3 columns are the attributes selected via the 3 dropdown inputs (data validation), the 4th contains the reference to the data table for every row (of permutations) as a string.
When you have your inputs, you can fetch the reference with eg
FILTER(Col4,(Col1=Input1)*(Col2=Inpout2)*(Col3=Input3))
Now that you have the reference, use INDIRECT to access.
Word of warning: This ain't great.
Thank you for this. I will try this out in the morning and send another reply once I've tested it