I have a workbook with 2 sheets packing and invoice .
The sheet packing have a breakdown of bottles in column E .
The sheet Invoice needs to be reconcile with packing sheet. as criteria Invoice and reference header .
I have tried to concatenate with index and match but falls shorts when there are duplicates with same invoice and reference but diffferent packing.
The formula takes the first one he finds.
In yellow issue with formula not giving correct answer
Can anyone assist,
Bookmarks