Dropdown list

image001.png

I have a question about dropdown lists. I want to make 3 dropdown lists (the last one dependent). Cell A12 and B12 are both drop down lists (not dependent). In the drop down list I have the options from A3:A5 and in B12 I have the options of B3:B5. If I choose Quadriceps in A12 and Balance in B12 I want all the exercises of the collum QuadricepsBalance. So that would be 5 exercises.


I hope there is a way tot do this. I'm not bound to the lay-out so I can change whatever I want to make it work.

Nice picture and now we can retype first? Place the file. See the big yellow banner

I can't place an attachment. It only shows a blank drop down. I can't do anything with it

Hi, Lucdejong
Welcome to the Forum.

Here's an example of 3 dependent data validation. It's using VBA (not formula), you need 1 actual table, 1 helper column & only 1 named range.
The code is rather long but the set up is pretty easy even if you don't understand the code.
Let me know if you're interested in this method.

Thank you guys I found a way. I no longer have this question. Thank you for all your time and effort