Workflow - Vlookup from mulitple Excels

[gavinloi]

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!

[binay2448 · Accepted solution]

Hope this will answer your question....

[messi007 · Accepted solution]

@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

[gavinloi]

Many thanks @binay2448  and @messi007! Both solutions worked wonders! 😀

[binay2448]

Happy to help😊