Error using studio x when to vlookup

Help StudioX
,
1

image
image1077×428 17.3 KB

may i ask regarding this error? before this this script is ok. im using studio x UiPath

2

@Nur_Amin

Can you please tell what is the value that you have given in the vlookup

As per error looks like the value provided is not string or the value returned is not

Cheers

3

the value to lookup is words for eg

first column second column( value to lookup)
1 a
2 b

4

@Nur_Amin

Can you try giving the input variable as var.ToString

And also give the output variable type as generic value if that supports

Cheers

5

hi where can i change this?

6

@Nur_Amin

In the search value field of vlookup …click on plus and open in advanced editor then give variable.ToString

And in the output field which ever variable is used in svae for later …change the dtatype to generic value

Cheers

7

image
hi where do i need to write the string?

8

@Nur_Amin

Try like this

CurrenRow.Byfield("Code").StringValue

Hope this helps

Cheers

9

hi for the output how? this is mine
image

10

@Nur_Amin

Output you are trying to save to same excel again?

If so try wothout changing only in output else assign to a variable and then use another assign to give the value to required cell

Cheers

11

yes in same excel, so i did not need to change anything right?

12

@Nur_Amin

Input you need to change as above …in output use as is

Cheers

13

hi i have try but the vlookup is not cpatured but it can run successfully

14

@Nur_Amin

That depends on the value and the column type you supply

cheers