topic RE: Perform Vlookp in Blueprism in Product Forum

Perform Vlookp in Blueprism

AsitabhaDeb — Wed, 30 Sep 2020 22:47:00 GMT

Hi,

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

BR/Asitabha

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

RE: Perform Vlookp in Blueprism

NileshJadhavBP — Thu, 01 Oct 2020 13:04:00 GMT

Hi,

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

Thanks
Nilesh

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

RE: Perform Vlookp in Blueprism

david.l.morris — Tue, 06 Oct 2020 12:46:00 GMT

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
------------------------------

RE: Perform Vlookp in Blueprism

SAINNATHSURAY — Thu, 24 Mar 2022 17:17:00 GMT

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
------------------------------