I have an excel worksheet
columns A - AA contain a lot of different fields.
Row 1 is my headers
Row 2 starts my data and I usually have around 55,000 rows of data that I import each month.
In Cell AH1 I have Sep
The most important columns are F - Q
F = Jan Amts
G = Feb Amts
H = March Amts
.....
Q = Dec Amts

In Cell AC2 I have this formula +N2
so when Oct comes I will entere +O2 and copy down.

Instead I want to enter a formula that identifies the value in AH1 and the pulls the amount from the correct column into AC.

Hope this makes sense.