Try to understand that method based on INDIRECT formula:
Or if you like VBA than try to set condition list every time you select something based on your rules in code
(not based on range)
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I have created a list of 5 Categories in Column D that users can choose from. Depending on what the user selects in Column D, I have created dropdown lists (utilizing vlookup) in Column E that correspond to that. Now I want to code something that clears column E every time the content of the Cell in Column D changes. So if a user has selected "equipment" in column D and selected "HR" in column E, and then the user changes Column D to "Expenses", the contents of the adjacent cell in column E clears to blank, with the drop down based on the value of column D.
Try to understand that method based on INDIRECT formula:
Or if you like VBA than try to set condition list every time you select something based on your rules in code
(not based on range)