Firstly, if you only show months up to A10, that means you only show 10
months, not 12.

You have to create a list of months, somewhere over to the right in you
spreadsheet, and then create a range name for each month. Iow, if you put
January in GG1, then you have to click on GG1, click in the address bar, and
enter January again.With February in GG2, you would do the same, and so on
till you have your 12 months.

In A2, insert the following formula, and copy it down to A10
=IF(A1="December",OFFSET(INDIRECT(A1),-11,0),OFFSET(INDIRECT(A1),1,0))

--

HTH

Kassie

Replace xxx with hotmail


"Dezzie" wrote:

Hello. I am creating an input area for another Excel user.

I would like A2:A10 to return the names of months in order, depending on
what month was in A1.

For example, if A1=January, then A2=February, A3=March, A4=April, etc.
But if A1=February, then A2=March, A3=April, A4=May, etc.

Is there a way to do this using IF and OR, or a simpler way?
As well, A1 is being chosen using a list. Does this complicate matters too
much, or can I leave it in? Thanks.
Thank you