If function with named lists (data validation)

  • Thread starter Thread starter jacki
  • Start date Start date
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
 
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()).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent Data Validation 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down List 7
If formula and Data Validation parallely 1
Indirect function and data validation dropdown box 2
Change drop down list in one cell based on values in other cells 2
Data Validation and drop-down list using IF, AND and what else? 8
Populating a data validation list based on criteria 3

Back
Top