Issue with VLOOKUP Activity in UiPath Studio

Help Studio
, ,
1

Hi UiPath Community,

I’m currently facing an issue with the VLOOKUP activity in UiPath Studio. I’m attempting to perform a VLOOKUP between two Excel sheets based on a date column, but I’m encountering a problem where UiPath Studio runs without any errors, yet it doesn’t print the output I expect.

Details:

  1. Activity: VLOOKUP
  2. Objective: Match data between two Excel sheets using a date column.
  3. Problem: UiPath Studio executes without errors but does not produce the expected output.
    4.Attempts: I’ve checked my inputs and formula, ensured that the range and lookup values are correct, but still unable to get the desired result.

Could someone please advise on what might be causing this issue or suggest alternative approaches to achieving a VLOOKUP functionality in UiPath Studio?

Thank you in advance for your help!

Best regards,
Puneet Kumar Sharma

2

Hi @Puneet_Kumar_Sharma

Can you provide input excels and required output using vlookup.
So that we will you out.

or
Try by updating the excel package by making runtime rule as lowest as applicable

image
image1111×951 78.1 KB

Regards

3

@Puneet_Kumar_Sharma

Please share the sample input and output

4

Hi @Puneet_Kumar_Sharma

For now can you try to Upgrade/Downgrade UiPath.Excel.Activities Package

Regards,

5

Screenshot 2024-07-19 165011
Screenshot 2024-07-19 165011477×750 37.7 KB

6

Hi @Puneet_Kumar_Sharma

Try by using Write cell activity by inserting the formula and use autofill range activity

Hope it helps!!