Perform Vlookp in Blueprism

[AsitabhaDeb]

Hi,

I would like to perform VlookUp in Blueprism. Is it possible? if Yes, then how.

BR/Asitabha

------------------------------
Asitabha Deb
------------------------------

[NileshJadhavBP]

Hi,

Yes its possible,You have to write code to achieve same in excel using Blue prism.

Thanks
Nilesh

------------------------------
Nilesh Jadhav
Senior RPA Specialist
------------------------------

[david.l.morris]

If you're saying you have a value that you know to be in one column of a collection and you want to retrieve a value from another column in the same row, then the easiest way is with Utility - Collection Manipulation::Filter Collection. Assuming that the value you're looking up is unique, it will return a single row. You just store that result into a new collection that will then only have one row and you just need to use a calculation stage after that to get the value from the other column like [collectionname.otherfieldname] and store it wherever, etc.

------------------------------
Dave Morris
Cano Ai
Atlanta, GA
------------------------------

[SAINNATHSURAY]

Hey Nilesh,

Can you guide how to use Vlookup between to excel through blueprism.

Thanks,
Sainath.

------------------------------
SAINNATH SURAY
Business process Lead
TATA CONSULTANCY SERVICE
Asia/Kolkata
------------------------------