Forum Discussion
Data validation based on value in a cell
Good afternoon,
If anyone could help, this would be great. I'm trying to build an Excel in which I can pick a brand in a cell based on data validation, than in another cell I would like to pick a series based on a reduced data validation. And so on with Typenummers.
So ideally, I would like to pick a Merk (for this example Lekker), then pick a Serie from a drop down that only shows XL and S (for this example S), and that select a Typenummers from a drop down that only shows 753 and 159.
Any advice is welcome, thanks!
Reinier - The Netherlands
2 Replies
I've not looked at HansVogelaar answer (as I'm in a hurry), but I would suggest looking at Dependent Drop-down lists. They are based around validation.
See the attached demo workbook.
