Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Facing issue while reading a cell value from excel which has a vlookup formuale

AravindBabu
Level 3

‎06-01-22 10:48 PM

Hi All, 

In my process i'm trying to read a excel file which has populated values by using vlookup formula.

------------------------------
Aravind Babu
RPA Developer

------------------------------
0 Likes
1 REPLY 1

devneetmohanty07
MVP

‎07-01-22 10:14 AM

Hi Aravind,

Can you let us know exactly what error you are facing or what kind of error message you are getting as 'Get Cell Value' from MS Excel VBO action would fetch the value from any cell having a formula.

You can refer to the below workflow for your reference and check if you are using something similiar, where I am fetching the lookup value via a VLookup formula in the cell "N8":

24425.png

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant
Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.
0 Likes