How can I combine 2 Excel files with Vlookup function in Alteryx?

[albertfung]

How can I combine 2 Excel files with Vlookup function in Alteryx?

[alexnajm]

VLookUps with Designer - Alteryx Community

[albertfung]

Thanks for your update.

How can I use perform calculation using Excel formula in the output (combined 2 Excel files)?

[alexnajm]

I am not sure of the question you are asking - the link above shows you the two best way to replicate VLOOKUP functionality in Alteryx. There is not a formula used

Here's another article: Alteryx for Excel Users: How to do a VLOOKUP in Alteryx

[albertfung]

How can I perform the sum function in columns and rows of Excel in Alteryx?

[alexnajm]

This is now a different question, so can you close out of this thread by accepting it and start a new discussion? I would also encourage you to look for the answer in the community here - the Learning Paths and the Interactive Lessons have this answer

[albertfung]

Thanks for your advice.