formula to get the perfect matches between 2 rows

[RAJESH1960]

Hello Guys,
I have this sheet where I have to get the Matches and Mismatches between Portal and Tally. Till now, I was using the formula shared by Mr. mikerickson, but today I noticed that when there are same or approximate amounts with a difference upto+1 or -1, which appear twice under the same GSTIN number, I was getting some mismatched amounts as matched. Earlier, when mikerickson shared the formula, I didn't share the columns of Invoice Number and Invoice Date as they were not always an exact match. Hope these columns are helpful in correcting the formula.
I need help to correct this formula and get the perfect matches. I am not sure but maybe a countif / s formula may solve the problem.
Sorry posted the wrong excel sheet. will post the right one in some time.

 

[KRice]

Are you looking at my post #4 column K...that is exactly what it shows. I don't see any problems with it. I'm assuming when you say "line" you are referring to the worksheet's row number (there is a column heading called "Line", but I'm not referencing that).

 

[RAJESH1960]

If the difference is more or less than10/- it is fine. But if there is a huge difference then the matches contain some mismatched amounts too.
Loading Google Sheets

 

[RAJESH1960]

Are you looking at my post #4 column K...that is exactly what it shows. I don't see any problems with it. I'm assuming when you say "line" you are referring to the worksheet's row number (there is a column heading called "Line", but I'm not referencing that).

I am referring to the row numbers.

 

[RAJESH1960]

I just checked your post #4. It is showing correct 2 matches. But the same formula in my sheet is showing 3 matches. I wonder why

 

[KRice]

Did you adjust the formula to fit the range in your sheet?

 

[RAJESH1960]

The only difference is you have entered the formula in row 3 in your sheet and I have entered in row 2. Let me try and insert a blank row and try again

 

[RAJESH1960]

Did you adjust the formula to fit the range in your sheet?

Yes. I inserted the formula in row 3 and copied it to row 2

 

[RAJESH1960]

insert a blank row and try again

This worked right now. How come.? Any idea.?

 

[RAJESH1960]

Is it possible to get the same correct result without inserting a row.?

 

[KRice]

A formula often depend on the table structure, so when the formula is pasted into a worksheet, you need to check all of the ranges and cell references. to ensure that they point to the correct locations. The blank row is not critical to the formula...but you need to examine the formula to ensure that it points to all of the correct ranges.