Forum Discussion
Populate a data validation drop down list based on a vlookup formula
Hi all have a problem with data validation that no one (Yet) seems to know the answer to. So, I have the following excel table with 2 columns (let's call it "table 1" column A & B): Setup ...
Here (attached) is an example I created of what I call "cascading data validation" where the secondary list is dependent on the first. You will need a current version of Excel, as this takes advantage of the relatively new FILTER function.
Thank you very much for the useful formulas.
Nonetheless, my problem is a bit more complex as I need to input data in multiple rows of a table but formulas work only for the first row. Every time I try using the drop down list in the below rows, the option are stuck based on the first row. How can this issue be solved?
- the option are stuck based on the first row?
hide selected options in previous rows?
https://techcommunity.microsoft.com/t5/excel/options-in-drop-down-lists/m-p/3959811
