Use RPA to realize Excel Vlookup function

Dear all,
I use the actions flow of [For Each] + [Counter] + [Flag] to realize Vlookup function between the target file and the database file.
Refer to the captures as below.

Database file:
db
Target file:
target
Actions Flow:


Result:
Result
Reference data: vlookup.zip (12.9 KB)
Notice: path variables must be matched with the actual file path

3 Likes

Great script @ShawnLi :heart_eyes:

Thanks a lot for sharing!