What is best approch for data mapping?
Like Manually in Excel we use Vlookup , what about in Automation Anywhere?
Hi
There are many ways we can achieve this, checkout below resources
Feel free to use Bot Store Bots as well,
https://botstore.automationanywhere.com/bot/a2019-excel-data-lookup-bot
OR
Also use Excel Advanced : Set cell Formula command,
Userlevel 7
+13
Hi
You can try using the Set Cell formula action to imitate the desired formula for the lookup.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.