Vlookup

[Meagan_Lalumiere]

I have 2 pieces of Excel (XLSX) data. The first is a list of codes and the negotiated price approved for this customer. The second is a sales history that shows every code that the customer ordered and what they paid for it. I am trying to do a vlookup to see what they paid vs what they should have and then provide the amount they over paid/credit owed to the customer.

[cjaneczko · Accepted solution]

The Join tool will do what you are looking for. Add it to the workflow and Join on Customer and Code.

[Bren_Spill · Accepted solution]

@Meagan_Lalumiere - see attached, doing what @cjaneczko recommended