how to add drop down list in google sheets

We return to the input sheet to set up the dependent dropdown list for the Apps. This match must be an exact match, so a 0 is used to set this behavior in the MATCH The third argument uses a MATCH function to locate the item listed in cell A3 of the input sheet within the list of Department in cells $A$3:$C$3.We want ALL ROWS to be returned, so we omit the second argument in the INDEX function, hence the 2 commas with nothing between them.

The INDEX function uses the first argument to select the array of cells $A$4:$C$20.To break the formula down into its pieces: The result is a list of Apps from the selected Division. To create a list of Apps that correspond to the user’s selection in the first dropdown ( cell A3 – input sheet), select cell F4, and enter the following formula. Each of these numbers corresponds to a “first” dropdown on the input sheet. Returning to the “Master” sheet, we will create a list of numbers from 1 to 10 in cells E4:E13. Creating the Data Preparation AreaĪs Google Sheets will not allow us to create a formula directly in the cell where the dropdown is to exist, we will write the formula in a “helper column” and reference the results with Data Validation. Remember we only wish to display Apps that are associated with the selected Division from the first dropdown list. These must work for each row independently of the adjacent rows. Now we create dropdown lists that are reactive to the first dropdown lists.

How to add drop down list in google sheets