Vlookup Error : DoubleConverter cannot convert from (null)

Help Activities
, ,
1

Hi all,

I am a beginner and I am currently doing the RPA developer foundation course. I am getting “DoubleConverter cannot convert from (null)” error while using Vlookup activity for consolidating two excel files as per the tutorial in the RPA developer foundation course.

Capture
Capture1397×648 39.5 KB

I also tried changing the type of the variable inside the Vlookup activity from Double to Generic Value. Even though it solved the error in the Vlookup activity it gave me another error in a Write cell activity called " Object reference not set to an instance of an object."

C2apture
C2apture1054×475 35.1 KB

Please help me solve this issue.
Thankyou.

1 Like
2

Hi @Gladin_Christy

The VLOOUP_Value variable is getting to be null. Please check the same.

image
image1324×602 166 KB

Cheers!!

3

@Gladin_Christy

As per error the variable is empty…the variable is empty because in vlookup either it did not find the value or the cell you are extracting via lookup is empty

Cheers

4

Hi @Gladin_Christy

If possible, you can share the lookup scenario.

I will provide a xaml file.

Thanks :slight_smile:

5

I also have same problem when I try to practice the function course.

I follow the direction that adjust the variable from string to double system, but the message " Vlookup Error : DoubleConverter cannot convert from (null)" was occured.

The image shows the UiPath Studio Community interface with a sequence workflow involving a VLookup activity and a Write Cell activity, along with the activities pane and test explorer windows visible. (Captioned by AI)
The image shows the UiPath Studio Community interface with a sequence workflow involving a VLookup activity and a Write Cell activity, along with the activities pane and test explorer windows visible. (Captioned by AI)1920×1080 265 KB

{BE0301A5-CFFC-4F9E-96DF-E184E2CF57A3}
{BE0301A5-CFFC-4F9E-96DF-E184E2CF57A3}1920×1080 265 KB

{F0AB8EDA-7B19-4350-A352-6CB43EE2C671}
{F0AB8EDA-7B19-4350-A352-6CB43EE2C671}1920×1080 265 KB

Please help me to solve this problem.

Thank you.

6

In the practice session it wants you to start looking from CurrentRow.ByField(“Doc. Number”) while you’re starting to look from the CurrentRow.ByField(“Total Sales”)

That’s why it shows you the “empty” Value.

The same issue is with the first post, the Excel file provided in course has a column header Doc. Number, not Document Number.

7

Before passing the data into the VLookup activity, use an If condition to check if the value is null or empty:

If String.IsNullOrEmpty(yourDataVariable) Then
’ Handle the case where data is null or empty
Else
’ Proceed with VLookup
End I

8

Did you got any resolution