Formulae Change each month

[philb99]

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

 

[James006]

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]

One way

Dropdown values in H1 are 1 -12

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][th]

G​

[/th][th]

H​

[/th][th]

I​

[/th][th]

J​

[/th][th]

K​

[/th][th]

L​

[/th][th]

M​

[/th][th]

N​

[/th][th]

O​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]Jan[/td][td]Feb[/td][td]Mar[/td][td]Apr[/td][td]May[/td][td]Jun[/td][td]Jul[/td][td]Aug[/td][td]Sep[/td][td]Oct[/td][td]Nov[/td][td]Dec[/td][td][/td][td=bgcolor:#FFFF00]

8​

[/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

835​

[/td][td]

272​

[/td][td]

670​

[/td][td]

285​

[/td][td]

427​

[/td][td]

266​

[/td][td]

666​

[/td][td]

487​

[/td][td]

464​

[/td][td]

696​

[/td][td]

754​

[/td][td]

348​

[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td]

487​

[/td][td] =INDEX(A3:L3,,$N$1)[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]