Excel Vlookup Using UiPAth

[arivu96 (Arivazhagan A)]

Hi @anshul_nema,
Refer this post,

Fastest way to write an excel formula into an entire column

Maybe of those approaches could help us to fulfill the entire column with the same formula, just replacing the row number from it. In this case, I would just write the formula at the first cell with Write Value activity and then apply one of those approaches following the link examples to replace the remaining rows: Using Send Hotkey activity to simulate the shortcuts that would help in this case. Using Mouse Click event (Double Clicking, more prone to errors) For example: [image] Never…

Regards,
Arivu