If function with named lists (data validation)

J

jacki

I have created named lists on sheet 2. If I want a drop down box t
appear in cell A2, I click data, validation, select list, and typ
=namedlist1.

Now, can I select cell B2 and create a function that says:

If cell A1 is equal to item 1, put drop down list 1 in cell A2
Else if cell A1 is equal to item 2, put drop down list 2 in cell A2
etc.

Thanks for any help
Jack
 
A

Aladin Akyurek

If your lists are named List1 and List2, using the Name Box, you can have:

=INDIRECT("List"&B2)

Note that this setup won't work if the lists are defined by means of dynamic
formulas (formulas with INDEX() or OFFSET()).
 
Top