excel

Hi @divakar ,

There are many ways we can achieve this, checkout below resources

Download Bot - https://botcenter.automationanywhere.com/Excel+Data+Lookup+Bot+v2+-+Automation+Anywhere.zip?_ga=2.145728572.926816202.1672030069-996033460.1670508869&_gl=1*1hfncc6*_ga*OTk2MDMzNDYwLjE2NzA1MDg4Njk.*_ga_DG1BTLENXK*MTY3MjY0NjY5My44MS4xLjE2NzI2NDc4MTcuMjEuMC4w

Get Instructions - https://botcenter.automationanywhere.com/excel-data-lookup-bot-automation-anywhere-readme.pdf?_ga=2.239520651.926816202.1672030069-996033460.1670508869&_gl=1*aw6kxd*_ga*OTk2MDMzNDYwLjE2NzA1MDg4Njk.*_ga_DG1BTLENXK*MTY3MjY0NjY5My44MS4xLjE2NzI2NDc4MTcuMjEuMC4w

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,

Hi @divakar 

You can try using the Set Cell formula action to imitate the desired formula for the lookup.