XLOOKUP Not Working

[MrDB4Excel]

Even though I use Excel 2013 I have the XLookup Addin and it always works perfectly.
Obviously, I don’t have this formula created correctly. My intent here is for the cells in column H to pick up the month indicated by the cells in columns A & B and that the lookup value is always only one of the 12 cells in column I that represents the month number.
As you can see by the XL2bb Mini Sheet it only works for the formula in cell H2. After this cell, H3 and after, the formula result goes haywire.
I have searched for an answer and tried several approaches but have come up with nothing that helps.
I would much appreciate any help offered.

BogusAutomatedMonthlyBudget.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Month	Date	Description	Income	Debits	Balance
2	1	Jan/06/2022	January Starting Balance	$1,000.00		$1,000.00	1	January	1	January
3	1	Jan/06/2022	Pension Deposit	$1,000.00		$2,000.00	1	September	2	February
4	1	Jan/06/2022	Medicare Part B		$100.00	$1,900.00	1	October	3	March
5	1	Jan/06/2022	Medicare Part D		$100.00	$1,800.00	1	November	4	April
6	1	Jan/07/2022	Rent		$600.00	$1,200.00	1	December	5	May
7	1	Jan/07/2022	Electricity		$120.00	$1,080.00	1		6	June
8	1	Jan/08/2022	Verizon		$100.00	$980.00	1		7	July
9	1	Jan/08/2022	Car Payment		$100.00	$880.00	1		8	August
10	2	Feb/01/2022				$880.00	2		9	September
11	3	Mar/01/2022				$880.00	3		10	October
12	4	Apr/01/2022				$880.00	4		11	November
13	5	May/01/2022				$880.00	5		12	December
14	6	Jun/01/2022				$880.00	6
15	7	Jul/01/2022				$880.00	7
16	8	Aug/01/2022				$880.00	8
17	9	Sep/01/2022				$880.00	9
18	10	Oct/01/2022				$880.00	10
19	11	Nov/01/2022				$880.00	11
20	12	Dec/01/2022				$880.00	12
2022

Cell Formulas
Range	Formula
A2:A20	A2	=IF((ISERROR(MONTH('2022'!$B2)))," ",(MONTH('2022'!$B2)))
B2:B20	B2	=IF(ISBLANK([BogusEasyAccounting2022.xlsx]Expenses!$B3)," ",([BogusEasyAccounting2022.xlsx]Expenses!$B3))
C2:C20	C2	=IF(ISBLANK([BogusEasyAccounting2022.xlsx]Expenses!$C3)," ",([BogusEasyAccounting2022.xlsx]Expenses!$C3))
F2	F2	=[@Income]
G2:G20	G2	=IF((ISERROR(VALUE(A2)))," ",(VALUE(A2)))
H2:H20	H2	=IF((ISERROR(XLOOKUP(I2,$G$2:$G$228,$J$2:$J$13,0)))," ",(XLOOKUP(I2,$G$2:$G$228,$J$2:$J$13,0)))
F3	F3	=SUM(F2+[@Income]-[@Debits])
D3:D20	D3	=IF(ISBLANK([BogusEasyAccounting2022.xlsx]Expenses!$E4)," ",([BogusEasyAccounting2022.xlsx]Expenses!$E4))
E4:E20	E4	=IF(ISBLANK([BogusEasyAccounting2022.xlsx]Expenses!$D5)," ",([BogusEasyAccounting2022.xlsx]Expenses!$D5))
F4:F20	F4	=F3+N([@Income])-N([@Debits])

And the support file:

BogusEasyAccounting2022.xlsx
	A	B	C	D	E	F
2	Month	Date	Description	Debits	Income	Balance
3	1	Jan/06/2022	January Starting Balance			$1,000.00
4	1	Jan/06/2022	Pension Deposit		$1,000.00	$2,000.00
5	1	Jan/06/2022	Medicare Part B	$100.00		$1,900.00
6	1	Jan/06/2022	Medicare Part D	$100.00		$1,800.00
7	1	Jan/07/2022	Rent	$600.00		$1,200.00
8	1	Jan/07/2022	Electricity	$120.00		$1,080.00
9	1	Jan/08/2022	Verizon	$100.00		$980.00
10	1	Jan/08/2022	Car Payment	$100.00		$880.00
11	2	Feb/01/2022				$880.00
12	3	Mar/01/2022				$880.00
13	4	Apr/01/2022				$880.00
14	5	May/01/2022				$880.00
15	6	Jun/01/2022				$880.00
16	7	Jul/01/2022				$880.00
17	8	Aug/01/2022				$880.00
18	9	Sep/01/2022				$880.00
19	10	Oct/01/2022				$880.00
20	11	Nov/01/2022				$880.00
21	12	Dec/01/2022				$880.00
22	1					$880.00
Expenses

Cell Formulas
Range	Formula
A3:A22	A3	=MONTH(B3)
F4:F22	F4	=SUM(F3+[@Income]-[@Debits])

 

[RoryA]

I don't really understand your formula at all. Why are you looking up the values from column I in column G? The reason you get September in H3 is that you are looking up I3, which is 2, in column G, which matches G10. The corresponding cell in column J is J10, which has September in it. Don't you just want a simple VLOOKUP of the values in column G against the values in I and return the relevant month name from J? For that all you need is:

=IFERROR(VLOOKUP(G2,$I$2:$J$13,2,FALSE),"")

 

[MrDB4Excel]

Your formula =IFERROR(VLOOKUP(G2,$I$2:$J$13,2,FALSE),"") works.
You bring to light some very important things to consider; that is, why and what is it I really need. So I will visit this in my bogus sheet to see why I want such results in my non-bogus sheet which obviously contains data I am not comfortable sharing in the mini sheets.
Ever learning. At the moment I am not sure now why I wanted to do this, but at the time I was looking at this it seemed important, so now I must take a serious look at it all.
Thank you so much for your help and for the good formula and for helping me to see beyond my nose.
Stay safe!