Drop-down list with hidden values

Hi!

I have to have a drop-down list, which will decide of a value to use for calculations (to print in a cell?). In that particular case, the choice has to be "Employees" or "Hours" (with an equivalence 1 employee = 40 hours). I want the choosing person to see the word "Employees" or "Hours", but not the associated numbers. I don't want to use cell space to plug in "Employees" next to "1" and "Hours" next to "40".

Is there a way to show the word "Hours" while calculations can be made with the value "40"?

Does this make sense?

Thanks!

You can define the values for the specific words in excel using "Names". If you are using 2003 version, under the insert menu you can see the option "Name". If you are using 2007 version, under the "Formulas" tab use the "Define Name".

Once the names are declared with the values, these can be used for calculations, but in the calculations you cannot see the actual values.

Hope this helps..

Thanks for your help, JBeaucaire!

Originally Posted by JBeaucaire

I have marked this thread solved for you.

I was kind of hoping, someone might have a "leaner" solution - it probably doesn't exist, you're right!

Kind regards
Stefan