Data Validation with list that points to other lists

[ravergirl7216]

Hi,
I would like to know if there is another way to do this for a data validation list.

in the data validation source I have:
=if(x=1, list1, x=2, list2, x=3, list3, etc.....
I have 12 lists to reference.

I heard you could use.
=INDIRECT(VLOOKUP(A1, B2:C14, 2, FALSE)
However, I've tried that and it is not working.

What am I missing here?
What should be in B2:C14 in the VLOOKUP?
The 1st column has numbers and the 2nd column has cells with data validations lists in them.

I'm trying to point one list to pull from another list.

Any help would be appreciated. Thanks!~

I'm running 2003.

 

[wigi]

Using cell E1 and for the rest, the same as you, this works perfectly:

=INDIRECT(IF(E1=1,"list1";IF(E1=2,"list2","list3")))

Consider the CHOOSE function to get rid of the IF's.

Wigi

 

[Brian from Maui]

Try,

In the Allow window, select List, in the Source window, enter

=CHOOSE(MATCH(A1,Number,0),List1,List2,List3,List4)

A1 is the cell where you enter 1,2,3, or 4

Where Number is a named ranged housing 1,2,3,4

List1, List2,List3,List4 are named ranges corresponding to the Number named range