Forum Discussion
Solved
Dependent Dropdown list With Filter Function
Hello everyone, I have been trying to create a database that includes dependent dropdown lists from a set of data. The data that I have consists of 2 columns vendors & merchandise. Column A | Colu...
Nevermore91 See attached. Some tricks are needed but I trust you will be able to replicate in with your real data.
Nevermore91 See attached. Some tricks are needed but I trust you will be able to replicate in with your real data.
- That works so well, but can I have a way where I don't change the row data at all?
thanks a lot thoSorry but I don't understand. What row data is it that you don't want to change?
Riny_van_Eekelen I don't want to transpose the data. I want to work on column A and B as is without transposing them. Also, in your provided example, I will have an issue if a 4th vendor is added. I will have to update the range in the xlookup from F3 to F4 and go through everything again which does not help unless if there is a workaround that.
