Formulae Change each month

philb99

Active Member
Joined
Feb 3, 2014
Messages
316
Office Version
  1. 2010
Platform
  1. Windows
I have data recorded in Month order going Jan to Dec in columns A to L

Information from the month columns are then fed into a separate table on the same page, the table is fixed in Columns N to W
For example A3 goes to N6 / A6 goes to N12 / A7 goes to N14 etc

But for the next month I have to amend the formula to pick from Column B to go to Cells N6 / N12 / N14 etc

Can someone help is providing any support in order that each month I do not need to keep updating the formulae for the change in the feed to the table in Columns N to W
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

James006

Well-known Member
Joined
Apr 4, 2009
Messages
3,680
Hello,

For sure there is a solution to create a generic formula ... which would be applicable to ALL the months ...

Many contributors could help you out ... as long as you can post your current formula ... and explain your expected result ...
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,695
Office Version
  1. 365
Platform
  1. Windows
One way

Dropdown values in H1 are 1 -12

Excel 2016 (Windows) 32 bit
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
1
JanFebMarAprMayJunJulAugSepOctNovDec
8​
2
3
835​
272​
670​
285​
427​
266​
666​
487
464​
696​
754​
348​
4
5
6
487
=INDEX(A3:L3,,$N$1)
Sheet: Sheet1
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,108,491
Messages
5,523,255
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top