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

On Wed, 11 Mar 2009 13:27:13 -0700, Selko
wrote:

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