You simply need to follow the additional step shown here.
http://www.contextures.com/xlDataVal02.html#Illegal

You can call the revised lists Two, Eight, Twelve, etc. since using the
actual numbers is not a viable option.

--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Roady" wrote:

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!