We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Vlookup

Meagan_Lalumiere
5 - Atom

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.

2 REPLIES 2
cjaneczko
13 - Pulsar

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

Bren_Spill2
12 - Quasar
12 - Quasar

@Meagan_Lalumiere - see attached, doing what @cjaneczko recommended

Labels
Top Solution Authors