Can anyone make this dependent?

[novakdz]

I have a list of unique values I need to make dependent, can anyone help?

[#2]

@novakdz Have a look at the attached!

[#3 · Accepted solution]

@novakdz I guess I finished baking "the cake" you found on youtube last week.

[#4]

Yes you did, you are the best!! Thank you so much for your help.

[#5]

I ran into an issue though, I only have excel 2016 so this formula doesn’t work for me :( any chance you know another solution?

[#6]

@novakdz Oh.... I thought you had access to Excel on Office365. Consider an upgrade, perhaps? For a relatively small fee per month you get the newest of the newest.

I recall that the video you found referred to "the old way of doing it". It took her 34 minutes to explain. Not sure I can do it any quicker. Can try to build something, but someone else out here might already have done it. Otherwise, invest some time in making the Named Ranges I talked about earlier. Relatively easy to make and maintain. Though not very "sexy".

[#7]

Okay and you don’t have to build anything else, thank you for your help. The named ranges go too confusing I will just try to upgrade.