Changing Column and Row Formula

[AshM91]

Hello,

I want to write a formula for when I update a "Reference" Sheet the letter i type in refers to the columns

For example

February is column: A
March is column : B

So in the month of February I want the cells to reference column A, but in March I want it to reference Column B.

The cell formulas are taking the values in column A and dividing it by static numbers in down the line in Column Z

February would be :

(A1/Z1)
(A2/Z2)
(A3/Z3)

March would be:

(B1/Z1)
(B2/Z2)
(B3/Z3)

And all i want to do is type in B in a reference cell such as Cell: AA1 i would type "B" to have to the fomulas update to reference column B.

Any help would be appreciated. Hopefully that made sense

 

[AlphaFrog]

Try something like this.
AA1 can be A-L and reference cells A1 to L1 (12 months). You could change that if needed.

=INDEX(A1:L1,1,CODE(UPPER(AA1))-64)/Z1

You could also pull the month from a date and reference a column based on the month number.