2 specific secondary drop down lists can be chosen after chosen specific option in primary

Originally Posted by SteveG

Hi,

Here is a workbook that shows tonalqualityx's suggestions using the INDIRECT function.

HTH
Steve


Attachment 159055

Thanks Steve! This is nice. The excel with IF station inside INDIRECT function works well, however I actually have many entries (more than 100) under Main list, therefore I have many sub-lists (around 50 each) and there are many entries under each sub-lists. It's painful to maintain such a long IF statement and there will be new entries to be added to these lists. Also there's a limitation of excel that max. 32 nested IF statements. So ultimately IF statement inside INDIRECT function won't work.

Can you make one excel sample using vlookup inside the INDIRECT function as mentioned by tonalqualityx? Or any better solution to handle many lists and many entries in the lists? Thanks!