All I have researched says I am doing it correctly, but cannot make a dynamic named range work if it is on another sheet.

All source lists and named ranges are on sheet1 and the dependent drop downs are on Dep. Drop Down sheet.

A2 drop down works fine with Blist, Clist, Dlist. They use non-Offset refers to formulas.

Alist uses this formula in the source box

OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$200), 1)

B2 drop down source box uses

=INDIRECT($A$2)

It's probably right at my feet, but can't figure???

Here is a link.

https://www.dropbox.com/s/4pyllrq4qo...rop%20Box.xlsm

Thanks,
Howard