Dynamic List applied to entire column

[kwdrus]

Hello all,

I am looking to create a dynamic list and need some help. In column "A" I need a drop down list which has 4 choices. I can do that part with a simple list in data validation. I would like the corresponding row in column "B" to have a list that references what was selected in column "A". Is it an =indirect function?

Thanks

list image.JPG

[MarvinP]

Hi kwdrus,

Is the attached what you are looking for. It uses Dynamic Named Ranges and Validation lookup names instead of fixed ranges.

DNR in Validation List Example.xlsx

If not then look for Dependent Validation Dropdown sites like:
https://www.ablebits.com/office-addi...n-lists-excel/