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. Excel sheet attached.
19.3 KB Views: 9