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, too. How can I determine the data of that column's cell by the selecting from fist four option?
Thank's for your answer!
Best regards,
L谩szl贸 Seller
4 Replies
- 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.- 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贸
- Post few of your sample data and then show your desired output. Better attach a sample file.
Dear Harun!
In the 1st column there the four data is big, green, boy, sun, and in the 2nd column the four possible (star, blue, whale, sark); (tree, grass, bush); (pants, bicycle, parachute, horse, soldier); (day, light, shadow). If I select green in the 1st column for example, then the (tree, grass, bush) should appear in the 2nd column's cell, as a possible choice.
Thanks for your help! 馃檪
L谩szl贸
