The drop-down list is made and the cells are linked with the list. This means that when you select “Hardware” in the drop-down list (E3), this refers to the named range “Hardware” (through the INDIRECT function) and thus lists all the items in that category.
In the “Source” box, apply the INDIRECT function:. Select cell F4 and go to “Data Validation” and select “List”. To complete the task, select the “ Hardware” and “ Software” column, go to “ Formula” and in the “ Name Manager”, click on “Create From Selection”.įormula → Name Manager → Create from Selection We have our drop-down list for the columns. Now in the new window, click OK to make the list. In the source field, assign the value =$B$4:$C$4 for selecting “Hardware” and “Software”. In the data validation dialogue box, select List as validation criteria. First, select cell E5 and go to the Data tab ->select Data Validation from the Data Tools group. We need to make a dependent list from that. Let’s discuss this.Ĭonsider this example where the “Hardware” and “Software” columns are given with some data. 
The dependent drop-down list also can establish links to their cell values and auto-update. Dependent Drop-Down List to Link a Cell Value So the cell values are linked with the list.Ģ.
Similarly, if we add some values to the “Item” the list will auto add these values. Then open the drop-down list and see that the list has auto-updated itself. Now let’s check whether this list is linked with a cell value or not. Then, click OK to get the drop-down list.
0 kommentar(er)
