Need help to find the reason for error

[RAJESH1960]

Hello everyone,
I have created this application with the help of formulas and VBA code. There are 6 code buttons to get the result which have to be pressed in the same order mentioned in column A. When I press all the buttons one by one, I am getting the result. I am facing 2 problems here and both are connected to the 2A Extract sheet.
In the column D of the 2A Extract sheet, this formula has to get the invoice numbers from B2B sheet of rows containing "-Total" after removing "-"Total" from the invoice number. But I am getting a few invoice number twice. That is one of the problems.

=IFERROR(IFERROR(VALUE(SUBSTITUTE(INDEX('2A'!$C$7:$C$10000,AGGREGATE(15,6,ROW($A$1:$A$9935)/(RIGHT('2A'!$C$7:$C$10000,5)="Total"),ROWS($1:1))),"-Total","")),SUBSTITUTE(INDEX(B2B!$C$7:$C$5963,AGGREGATE(15,6,ROW($A$1:$A$5927)/(RIGHT(B2B!$C$7:$C$5963,5)="Total"),ROWS($1:1))),"-Total","")),"")

Again, in the 2A Extract sheet invoice value column the problem is it is not getting the invoice value in some rows. Rows 73 & 74.
I need your help to solve these 2 issues.
PS: Run the code buttons one by one to get the data displayed.

Errors pending to correct.xlsm

 

[RAJESH1960]

Got it. Anthony47. I found the mistake. I was supposed to take the invoice number from B2B sheet in the formula and I entered 2A sheet and got the multiple Invoice numbers.
Thank you Anthony for trying to help me. I really appreciate it man.

 

[RAJESH1960]

FYI the formula in 2A Extract sheet column D was supposed to be

=IFERROR(IFERROR(VALUE(SUBSTITUTE(INDEX(B2B!$C$7:$C$10000,AGGREGATE(15,6,ROW($A$1:$A$9935)/(RIGHT(B2B!$C$7:$C$10000,5)="Total"),ROWS($1:1))),"-Total","")),SUBSTITUTE(INDEX(B2B!$C$7:$C$5963,AGGREGATE(15,6,ROW($A$1:$A$5927)/(RIGHT(B2B!$C$7:$C$5963,5)="Total"),ROWS($1:1))),"-Total","")),"")

 

[Anthony47]

Look for example at Invoice # 2107, the first one with #N/A in column F
Its column A says 27AAACJ8702F1ZQ (gstn supplier)
But in B2B, Invoice # 2107 is associate with a different gstn supplier

Then the N/A

Let me check...

 

[Anthony47]

YOU GOT the solution while I was still looking the chain that get the result
Good!

 

[RAJESH1960]

YOU GOT the solution while I was still looking the chain that get the result
Good!

Like when I was explaining the problem to you, I noticed that the Invoice number was taken from 2A instead of B2B sheet. Thanks to you.