Validation List to fill adjacent cell with IF?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

braeden13 - 13 Mar 2008 22:31 GMT

I am trying to set up a drop down list (list is set up ok) that has the
months of the year in it to correspond with a number for the month using IF,
but it doesn't seem to work. Here is the formula I was trying in cell A2:

IF(A1="January",(1))*IF(A1="February",(2))...etc.

The value in A2 comes back as 0 or #NAME. Obviously this is not the way to
set this up, but I am unsure how to make it work. Is there somewhere I can
look this up or does someone have a formula to use? I use Excel 2002 and
2003.

Reply to this Message

Bob Phillips - 13 Mar 2008 22:43 GMT

How about

=MONTH(DATEVALUE("01-"&A1&"-2000"))

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am trying to set up a drop down list (list is set up ok) that has the
> months of the year in it to correspond with a number for the month using
[quoted text clipped - 9 lines]
> look this up or does someone have a formula to use? I use Excel 2002 and
> 2003.

Reply to this Message

Teethless mama - 14 Mar 2008 03:54 GMT

=MONTH(A1&" 1")

> I am trying to set up a drop down list (list is set up ok) that has the
> months of the year in it to correspond with a number for the month using IF,
[quoted text clipped - 6 lines]
> look this up or does someone have a formula to use? I use Excel 2002 and
> 2003.

Reply to this Message