Solved! Go to Solution.
Hi @Nikhil8087
This article does a great job on explaing how to turn your EXCEL formula into Alteryx workflows:
https://www.alteryx.com/alteryx-excel
The Join Tool and the Find and Replace Tool can mimic the Lookup function.
Cheers,