Help with data valiation (indirect function)

[novakdz]

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.

Example: if you choose vendor "A" only vendor A item type shows up, and then only vendor A details.

Please let me know if there is a solution,

Thank you for your time and your help.

Sincerely,

Dan

[#2]

@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-validati... 

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

[#3]

Yes but where I got stuck was the duplicate data. I can’t remove it, I have to reference all the data in each category since each final test is different.

I was trying to make a drop down list like this: https://www.xelplus.com/extract-unique-items-for-dynamic-data-validation-drop-down-list/
but I couldn’t figure it out the formula was too complex.

Please let me know if you have any recommendations,

Thank you

[#4]

@novakdz 

Must admit I'm progressing slowly. But, if you would consider to reorganise your lists (started with an example in Sheet1 in the attached workbook), I'm confident it can be achieved. But now I must, unfortunately go off-line for a while.

[#5]

I appreciate all your help I was able to watch the video and download the spreadsheet to create my unique validation list. Now I’m using this video and spreadsheet to do the rest. https://youtu.be/gu4xJWAIal8

Thank you again for your help.

[#6]

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

https://youtu.be/2USJsIyIzvo

This is cake