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 ...
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
hide selected options in previous rows?
https://techcommunity.microsoft.com/t5/excel/options-in-drop-down-lists/m-p/3959811