Help with Formula (Match)

Hi all,
Need some help on a formula, hope someone can find time to take a look at it.
So basically, On the table "Total Summary", I would like to get the values for each month based on what is on the heading.
The value is found on the tables on the right hand (all greyed out).
I know I can just do an = and point it to the corresponding value, however, I thought there's another way of doing this.

For Example:
JAN 2016 the Actual budget should be equal to the JAN 2016 in the Table below (that would be 1,111 as per sample sheet)
FEB 2016 the Actual budget should be equal to the JAN 2016 in the Table below (that would be 2,222 as per sample sheet)
.
.
.
And So on

JAN 2016 the Budget should be equal to the JAN 2016 in the Table below (that would be 5,555 as per sample sheet)
FEB 2016 the Budget should be equal to the JAN 2016 in the Table below (that would be 6,666 as per sample sheet)

I hope I am making sense. Thank you and looking forward to your help.

Hi,

Try this formula in C4 and drag across

Formula:

Please Login or Register  to view this content.

see attached

This maybe?

Excel 2010 32 bit

	B	C	D	E	F	G
2		YEAR-TO-DATE
3		Actual	Budget	PY Sales	Actual vs Budget	Index %
4	JAN 2016	1,111	5,555
5	FEB 2016	2,222	6,666

Sheet: Sheet1

Excel 2010 32 bit

	C	D
4	=Q18	=R18
5	=OFFSET(Q18,,12*ROWS($C$5:$C5))	=OFFSET(R18,,12*ROWS($C$5:$C5))

Sheet: Sheet1

Thanks for the rep - glad to have helped.