I have one shipment (Tracking #), that has many charges associated with it.
However, they are on two different reports.
I am looking for a large & index combined formula but need some help.
I have attached a workbook with two sheets and sample data.
The LIST sheet has the single instance, but there are many charges associated with that one sale.
The CHARGES sheet shows the charges associated with the sale.
The unique item is the Tracking. I need to pull columns B&C from Charge into the List - matching on the Tracking #.
I need to list them on the same row - Surcharge 1, surcharge 2, surcharge 3....