Workflow - Vlookup from mulitple Excels

Question

Hi all,

I am trying to create an alteryx workflow and would require some help to do multiple vlookups from different excels.

I would need the final output in Test C excel whereby :

(1) Test C's Name would vlookup against Test A Number

(2) Test C's Number would vlookup against Test A Name

(3) Test C's Name would vlookup against Test B status

(4) Test C's Name would vlookup against Test B country

Would this actually be possible ?

Test A

Test B

Test C

Thank you!

Test C.xlsx

Test B.xlsx

Test A.xlsx

binay2448 · Accepted Answer

Hope this will answer your question....

messi007 · Accepted Answer

@gavinloi,

Please see below:

I did the vlookup with names between the C and A as if I add number I'll lose some rows.

You can update it and add the number on the first join

Attached the workflow.

Hope this helps!

Regards