Stuck with a Simple Formulae

**bengaluru** · 12-06-2006, 01:10 PM

I have a drop down menu with 1 to 12 and when a user choses any of the numbers the corresponding month would come up in the next cell. for example if I choose 3 - the next cell would show up as March 07.

It works fine for only 8 months and does not work beyond that. This is my formula at the cell where the name of the month should come up.

=IF($C$4=11,E69,IF($C$4=12,E70,IF($C$4=1,E59,IF($C$4=2,E60,IF($C$4=3,E61,IF($C$4=4,E62,IF($C$4=5,E63,IF($C$4=6,E64,"NONE"))))))))

where C4 is the cell with the drop down menu (1 to12). I have the list of names of months at Cell E 59 to E 71 , which should appear in the Cell B4 when selected.

Is there a limitation in the use of number of cells ? What am I doing wrong here ?

Thanks for your help, guys.

**chilipepr** · 12-06-2006, 01:20 PM

your if than esle only has 8 cases in it (1,2,3,4,5,11 and 12).

wouldn't it be easier to put 1 thru 12 in column D (to the left of the corresponding date) and then make your formula:

=vlookup($C$4, $D59:$D70, 2, false)

**bengaluru** · 12-06-2006, 03:40 PM

Thanks chilipepr.

As I mentioned it was taking only 8 and hence I used 11,12,1 to 6.

Maybe I did not explain this properly. My dropdown menu is in C4 and I want the result in B4. The formula is not taking more than 8 cases.

**chilipepr** · 12-06-2006, 04:11 PM

There is a limit of 8 nested if statements in excel... can you use the vlookup statement?

**Maistrye** · 12-06-2006, 04:19 PM

You could probably use this:

=IF(AND($C$4>=1, $C$4<=12),OFFSET(E58,$C$4,0),"None")

From E58, it offsets the number of rows equal to what is in your dropdown list.

Scott