Hi all,

I'm facing the following problem:

in cell A1, there's a drop-down list, where only one of a list of values can be selected (January, February, March, [...], December).

I'd like to put a formula in cell B1, so that B1 = The following value in the list, in relation to the value selected in A1.

That is: if the user selects "March", for example, in the drop-down list in A1, cell B1 will automatically display the value "April".

How can I do this with a formula?

Many thanks in advance
Bruno