Vlookup modern activity errror

Help Studio
, ,
1

Hi Team,
I am getting some error mention below when i used vlookup modern activity and lookup value is not a null,but lookup does not match.

The image shows a debugging interface for an Excel VLookup operation with an error message stating, "VLookup: Cannot convert Excel Value to System.Int32." (Captioned by AI)
The image shows a debugging interface for an Excel VLookup operation with an error message stating, "VLookup: Cannot convert Excel Value to System.Int32." (Captioned by AI)1457×795 56.7 KB

2

If your lookup value is a number, force UiPath to treat it as a string:
CStr(yourLookupValue)
eg: CStr(row(“LookupColumn”))

3

i could not understand

4

Correct me if I’m wrong I think your Result variable is of type Int32 which is incorrect.

it should be of type Excel

  • Save to - Click Plus on the right side of the field and then, from the menu, select where to save the result:

  • Select an Excel file and then a named cell, or select Indicate in Excel to indicate a cell from the file.

  • Save for Later Use - Save the result for later use in your project as input for another activity.

  • Open in Advanced Editor - Enter a VB expression.

5

Hello,

If your lookup value is a number, force UiPath to treat it as a string:
CStr(yourLookupValue)
eg: CStr(row(“LookupColumn”))

6

Hi, create a variable of type object and use that variable instead.

7

@JK_MECH

the error suggests your output variable is of wrong type…

I guess you gave int32…if so change result type to Object

cheers