Formula to get match if difference is +1 / -1

[RAJESH1960]

Hello formula experts
I am trying to match Portal with Tally and get the matched rows. If the amount has a difference of about +1 or -1 then also it should consider as a match. With this formula I am getting an exact match, but not the amounts which have a difference of +1 or -1. I need your expertise to edit the formula to get all the matches with a formula, even if there is a difference not more than +1 or -1.
I had posted the same query on Excel Ask & Answer a few days back but the query remains unsolved.
Excel Ask & Answer

Query to match portal with Tally.xlsx
	A	B	C	D	E	F	G	H
1	Line	AS per	ID No.	D	Remarks	F	G	Amount
2	2	PORTAL	29EULXB5486E1XM		Matched			21,600.00
3	3	PORTAL	29EULXB5486E1XM		#N/A			58,205.00
4	4	PORTAL	29EULXB5486E1XM		#N/A			13,000.00
5	6	PORTAL	29EULXB5486E1XM		#N/A			27,553.00
6	48	PORTAL	33EEFFB2045M1XN		#N/A			20,768.50
7	74	PORTAL	29EWXXM8712Q1XF		#N/A			2,761.00
8	87	PORTAL	36ECQXH8295Q1XF		#N/A			21,000.00
9	88	PORTAL	36ECQXH8295Q1XF		Matched			7,080.00
10	103	PORTAL	27EEECI7904G1XN		#N/A			1,069.08
11	115	TALLY	29EULXB5486E1XM		Matched			21,600.00
12	133	TALLY	29EULXB5486E1XM		#N/A			58,204.00
13	138	TALLY	29EWXXM8712Q1XF		#N/A			2,761.50
14	139	TALLY	36ECQXH8295Q1XF		#N/A			21,381.00
15	143	TALLY	33EEFFB2045M1XN		#N/A			20,768.00
16	146	TALLY	29EULXB5486E1XM		#N/A			12,999.50
17	164	TALLY	29EULXB5486E1XM		#N/A			27,555.00
18	167	TALLY	36ECQXH8295Q1XF		Matched			7,080.00
Portal + Tallly Match

Cell Formulas
Range	Formula
E2:E18	E2	=IF(MATCH(1,(H2=$H$2:$H$23200)*(C2=$C$2:$C$23200)*(B2<>$B$2:$B$23200),0),"Matched","")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[mikerickson]

Replace (H2=$H$2:$H$23200) with (ABS(H2-$H$2:$H$23200)<=1)

 

[RAJESH1960]

Replace (H2=$H$2:$H$23200) with (ABS(H2-$H$2:$H$23200)<=1)

If you mean like this
=IF(MATCH(1,(ABS(H2-$H$2:$H$23200)<=1))*(C2=$C$2:$C$23200)*(B2<>$B$2:$B$23200),0),"Matched","")
It is not accepting it. Or do you mean to say that I have to replace all the ranges....?

 

[mikerickson]

There is one too many right parenthesis.

 

[RAJESH1960]

I tried this too but it ain't working.

=IF(MATCH(1,(ABS(H2-$H$2:$H$23200"<"&$H2+0.5,$H$2:$H$23200,">"&$H2-0.5)=1,*(C2=$C$2:$C$23200)*(B2<>$B$2:$B$23200),0),"Matched","")

 

[mikerickson]

What is this portion supposed to do and why are the inequalities text symbols?

(ABS(H2-$H$2:$H$23200"<"&$H2+0.5,$H$2:$H$23200,">"&$H2-0.5)=1

 

[RAJESH1960]

What is this portion supposed to do and why are the inequalities text symbols?

(ABS(H2-$H$2:$H$23200"<"&$H2+0.5,$H$2:$H$23200,">"&$H2-0.5)=1

I had a CF formula which I just tried to edit to get the amounts with the difference. But was not able to. Not so good at these kind of formulas.

 

[mikerickson]

As I said above in the OP formula replace (H2=$H$2:$H$23200) with (ABS(H2-$H$2:$H$23200)<=1)

 

[RAJESH1960]

As I said above in the OP formula replace (H2=$H$2:$H$23200) with (ABS(H2-$H$2:$H$23200)<=1)

Oops.... I forgot to press control shift enter. It is perfect. Thanks mikerickson. ?