Hi:

I have two columns as follows:
Dept Brand
2 Hanes, Leggs
8 Converse, Aerosoles
12 Levi's, Dockers

When the user selects the dept # in col A, I want it to restrict the
drop-down in Col B to only show the applicable brands. Problem is I can't use
the typical Indirect formula method because it won't allow me to name the
cell with a number.

Can you offer an alternative? Thanks!