Drop down list

S

Selko

how can i make a drop down list that contains names, and changes the values
of the formulas for that name?
 
G

Gord Dibben

The formulas would use the INDIRECT formula to use the name from the
dropdown list.

But not enough detail to make a guess.

Are the names defined names for ranges? Or maybe sheet names?

Post a sample of your current formulas and how you want them to react to the
names in dropdown list.


Gord Dibben MS Excel MVP
 

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

Filtered drop down list 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down List Contains the List Header Row 1
Filter a Drop List ? 1
drop down list should remember selection. 6
How can I populate a drop down list from Data Validation? 1
Drop down list - how doo I make selection disapear? 4
DROP DOWN LIST WHEN SPREAD SHEET OPENS 5

Top