Hi all - new joiner and in desperate need of some help please! I'll try and explain this as well as I can :-)
I want to create a series of logical option tables in excel that goes something like:
IF I choose Option 1 in dropdown table 1
THEN show me these options in dropdown table 2
IF I choose Option 3 in dropdown table 2
THEN show me these options in dropdown table 3
IF I choose Option 25 in dropdown table 3
THEN show me these options in dropdown table 4...
And so on and so forth. So I'm left with a dynamic logic tree that only allows you to choose options based upon your previous selection.
I've tried using several IF forumalas, VLOOKUP and a few others, and am getting nowhere :-(
Any help hugely appreciated, thank you!!