Look up monthly budget/actual based on input month

[fishmonger]

I am trying to create formula to look up actual/budget numbers from data range. Is it possible to do this if my data is structured like this or i would need to add a helper row?
Thank you.

Book2.xlsx
	A	B	C	D	E	F	G
1		Jan-24	Jan-24	Feb-24	Feb-24	Mar-24	Mar-24
2		Budget	Actual	Budget	Actual	Budget	Actual
3
4	Revenue
5	Merchandise sale	200	150	300	250	400	350
6	Training	55	60	65	70	75	80
7
8	Expenses
9	Wages	25	30	35	40	45	50
10	Supplies	5	10	15	20	25	30
11
12
13	Put Month here =>	03/2024
14		Month Budget	Month Actual	Variance
15	Revenue
16	Merchandise sale
17	Training
18
19	Expenses
20	Wages
21	Supplies
Sheet1

 

[Cubist]

To make things a little easier, I changed the headers in row 14 to match row2. Try:

Book1
	A	B	C	D	E	F	G
1		1/1/24	1/1/24	2/1/24	2/1/24	3/1/24	3/1/24
2		Budget	Actual	Budget	Actual	Budget	Actual
3
4	Revenue
5	Merchandise sale	200	150	300	250	400	350
6	Training	55	60	65	70	75	80
7
8	Expenses
9	Wages	25	30	35	40	45	50
10	Supplies	5	10	15	20	25	30
11
12
13	Put Month here =>	3/1/24
14		Budget	Actual	Variance
15	Revenue
16	Merchandise sale	400	350
17	Training	75	80
18
19	Expenses
20	Wages	45	50
21	Supplies	25	30
Sheet8

Cell Formulas
Range	Formula
B16:C17,B20:C21	B16	=INDEX($B$5:$G$10,MATCH($A16,$A$5:$A$10,0),MATCH($B$13&B$14,$B$1:$G$1&$B$2:$G$2,0))

 

[fishmonger]

Thanks !!!!!