Clear cell contents derived from vlookup using VBA

Question

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.

Answer 1

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)