Hey,

I Am working on an assignment where i making approval note against all invoices of suppliers in the particular month
The Problem i am having is that data base from where picking invoices have 2-3 part of one invoice ( Gross Amount, Tax On Invoice, WHT on Invoice ) So when i apply formula
=INDEX('LSA Charges'!$D$7:$D$674,AGGREGATE(15,6,(ROW('LSA Charges'!$A$7:$A$674)-ROW('LSA Charges'!$A$7)+1)/($B22='LSA Charges'!$A$7:$A$674),COUNTIF($B$22:$B22,$B22)))
It Returns Value But Picking All Invoices Including It's Tax and WHT
I Tried To Give Same Name to All Three Invoices So Possibly I Skip Invoice Screenshot (9).pngScreenshot (8).png