Coding drop down list results as numbers

C

chan_siu_man

I was wondering if there is a way to have excel code results from a dro
down list numerically?

ie, let's say we do Days of the week. Ideally, I'd like to create
spreadsheet such that the drop down menu lists the days of the wee
Mon-Fri, but after I've clicked on the day I want, it enters a numbe
into the excel cell (Mon-1, tues-2, wed-3 etc..)

Is there a way to do this?

Thanks,
Simo
 
B

Biff

Hi!

You can use a combo box from the forms toolbar and link the cell where you
want the number to appear. The linked cell will return the number of the
item selected that is relative to the list:

Monday
Tuesday
Wednesday

If you select Tuesday the linked cell will return 2 because Tuesday is the
second item in the list.

Or, use this formula:

Assume the drop down is in cell A1.

Enter this formula in cell B1:

=IF(A1="","",MATCH(A1,{"Monday","Tuesday","Wednesday","Thursday","Friday"},0))

Biff

"chan_siu_man" <[email protected]>
wrote in message
news:[email protected]...
 
Top