Multiple dependent columns without defined list of values

candace_tt 

You can achieve this by using a combination of data validation and the INDIRECT function.

Here’s how you can do it:

1. Create a named range for each module that contains the corresponding Object IDs. For example, create a named range called “PM” that contains all the Object IDs for the PM module, a named range called “SCM” that contains all the Object IDs for the SCM module, and so on.
2. In the cell where you want to create the drop-down list for Object IDs, use data validation with the INDIRECT function to create a dynamic list based on the selected module.

For example, if the selected module is in cell B2, you can use the following formula in the data validation source field: =INDIRECT(B2). This will create a drop-down list that displays the Object IDs for the selected module.

1. To auto-populate the Object Name based on the selected Object ID, you can use a VLOOKUP or INDEX/MATCH formula. For example, if the selected Object ID is in cell C2 and your data table is in cells A2:D8, you can use the following VLOOKUP formula to return the corresponding Object Name: =VLOOKUP(C2,A2:D8,4,FALSE).

I hope this helps! 

NikolinoDE

I know I don't know anything (Socrates)