Forum Discussion
Excel question
Hi, I have an Excel file, with 3 datashett. On the 1st datasheet there is a column, with cells with scrolling list with 4 possibility. The data of the next column's cell are from a scrolling list...
To determine the data of the next column's cell based on the selection from the first four options, you can use Excel's Data Validation feature along with dependent dropdown lists. Here's how you can set it up:
1. **Create the First Dropdown List**:
- Select the cells where you want the first dropdown list to appear.
- Go to the "Data" tab and click on "Data Validation."
- Choose "List" as the validation criteria.
- Enter the four options separated by commas in the "Source" field.
- Click "OK" to create the dropdown list.
2. **Create the Dependent Dropdown List**:
- In the next column, where you want the dependent dropdown list, select the cells.
- Again, go to the "Data" tab and click on "Data Validation."
- Choose "List" as the validation criteria.
- In the "Source" field, use a formula to specify the options based on the selection in the first dropdown list. For example, if the first dropdown list is in column A and your options for the second dropdown list are in column B, you can use a formula like `=INDIRECT("B"&MATCH(A1, $A$1:$A$4, 0))`.
- Click "OK" to create the dependent dropdown list.
Now, when you select an option from the first dropdown list, the options in the second dropdown list will change accordingly based on your selection. This allows you to determine the data of the second column's cell by selecting from the first four options.
1. **Create the First Dropdown List**:
- Select the cells where you want the first dropdown list to appear.
- Go to the "Data" tab and click on "Data Validation."
- Choose "List" as the validation criteria.
- Enter the four options separated by commas in the "Source" field.
- Click "OK" to create the dropdown list.
2. **Create the Dependent Dropdown List**:
- In the next column, where you want the dependent dropdown list, select the cells.
- Again, go to the "Data" tab and click on "Data Validation."
- Choose "List" as the validation criteria.
- In the "Source" field, use a formula to specify the options based on the selection in the first dropdown list. For example, if the first dropdown list is in column A and your options for the second dropdown list are in column B, you can use a formula like `=INDIRECT("B"&MATCH(A1, $A$1:$A$4, 0))`.
- Click "OK" to create the dependent dropdown list.
Now, when you select an option from the first dropdown list, the options in the second dropdown list will change accordingly based on your selection. This allows you to determine the data of the second column's cell by selecting from the first four options.
Dear Sarah!
Thanks for your help!
I did it, what you suggested. But in the 2nd list did not chang depending on the choice in the first column. Plesa read, what I wrote to Harun on this topic. There is a short example.
László
Thanks for your help!
I did it, what you suggested. But in the 2nd list did not chang depending on the choice in the first column. Plesa read, what I wrote to Harun on this topic. There is a short example.
László