Forum Discussion

Copper Contributor

Feb 18, 2020

Help with data valiation (indirect function)

Hi, I have a list of tests reports I need to pull based off specific criteria from each drop down. I already have the list established but I need it to be dependent for each choice. Exam...

Letter Tracker.xlsx26 KB

excel

Formulas and Functions

Riny_van_Eekelen

Platinum Contributor

Feb 18, 2020

novakdz Similar to a problem that came up earlier today in this thread.

https://techcommunity.microsoft.com/t5/excel/expand-amount-of-characters-for-source-in-data-validation/m-p/1179046#M52658

Working with Named Ranges and INDIRECT will enable what you want to achieve, though you have to restructure your option lists.

novakdz

Copper Contributor

Feb 18, 2020

Found the best and easiest way to do this if you have the most recent excel update.

https://youtu.be/2USJsIyIzvo

This is cake