Offset, Index and match combined

[Spennny]

Hi All, Can someone help an idiot with the combined formula,

TIA

 

[oldbrewer]

show us data and a desired outcome, please.

 

[Spennny]

Basically i have a unique key, as i change the month at the top i would like it to pull in the data relating to that month , i'll have to mock up a table as i cant share the data , sorry

 

[oldbrewer]

formula

col H

jan

feb

mar

april

may

row 10

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
[TD="width: 64"]mar[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]

[TD="align: right"]61[/TD]

[TD="colspan: 5"]=OFFSET($G$10,1,MATCH(A1,$H$10:$L$10,0))[/TD]

[TD="align: right"]55[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]61[/TD]
[TD="align: right"]59[/TD]
[TD="align: right"]77[/TD]

</tbody>