How do I create a dynamic drop down list in Google Sheets | Dependent Dropdown List Row Wise

Описание: Creating a dynamic dependent drop-down list in Google Sheets involves using the "Data Validation" feature along with the "INDIRECT" function. This method allows you to create a list in one cell based on the selection made in another cell.

Let's assume you have two columns, one for the main category and another for the dependent subcategory. Here are the steps to create a dynamic dependent drop-down list row-wise:

Step 1: Set up your data
In your Google Sheet, set up two columns. For example, let's say you have categories in column A (A2:A100) and subcategories in column B (B2:B100). Each row will represent a pair of main category and dependent subcategory.

Step 2: Create named ranges
Select the cells containing your main categories (e.g., A2:A100).
Go to "Data" in the menu, and then select "Named ranges."
Enter a name for the range (e.g., Categories) and click "Done."
Repeat the process for the subcategories (e.g., B2:B100, name it Subcategories).
Step 3: Set up Data Validation
Select the cell where you want the main category drop-down list to appear (e.g., C2).
Go to "Data" in the menu, and then select "Data validation."
In the criteria section, choose "List of items" and enter =Categories as the criteria range.
Click on "Cell range" and select the cell where you want the drop-down list (e.g., C2).
Click "Save."
Step 4: Create a dependent drop-down list using INDIRECT
Now, select the cell where you want the subcategory drop-down list (e.g., D2).
Go to "Data" in the menu, and then select "Data validation."
In the criteria section, choose "List of items" and enter =INDIRECT("Subcategories") as the criteria range. The INDIRECT function here allows the subcategory list to be dependent on the main category selection.
Click on "Cell range" and select the cell where you want the drop-down list (e.g., D2).
Click "Save."
Now, when you select a main category in column C, the corresponding subcategories will be available in the drop-down list in column D.

Repeat these steps for each row where you want dynamic dependent drop-down lists. Adjust the cell references and named ranges accordingly if your data is in different columns or rows.
#googlesheetstutorial
#msexcelfullcourse
#msexcel
COMMUNICATE WITH HASAN ACADEMY
[email protected]
Facebook page
  / hasanacademybanglatutorial  

Subscribe link :    / @hasanacademy779  
Facebook group link :   / 282270382269650