Peak Seagull
New Member
- Joined
- Oct 15, 2019
- Messages
- 2
I’m trying to set up a table where you can have multiple dynamic lists. For example, column 1 has a drop-down list containing the asset group, column 2 would then have a sub-category if there is one otherwise it would remain blank and column 3 would then show the correct assets attributable to each asset group or sub-category. Is this possible? I’ve tried the INDIRECT function mixed with a VLOOKUP but haven’t managed to do it correctly.