First, create another worksheet where we will make the hyperlink list.One of them got data for “Hardware”.Īnd the other stands for the data of “Software”. Here, we have two worksheets and name them “Hardware” and “Software”. In this method, we will make a hyperlink drop-down list. Hyperlink Drop-Down List to Link a Cell Value Read more: How to Make a Drop-Down List Based on Formula in Excelĥ. Here, apply the VLOOKUP function in the cell “F5”. First, make a drop-down list in the cell “E5” just like Method 1 using the source data as the cells of the “Item Name” column.We will make a drop-down list, and link the cell values with the list using the VLOOKUP function. In the following example, the list of the “Item name” and their “Price” are given. We can use the VLOOKUP function to link the cell with the drop-down list. Read more: How to Create Dynamic Dependent Drop Down List in Excel To prove that the cell values are linked with the list, you can add or subtract any value from the source list and can check that the drop-down list is auto-updating itself.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.
0 Comments
Leave a Reply. |