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
the value to lookup is words for eg
first column second column( value to lookup)
Can you try giving the input variable as var.ToString
And also give the output variable type as generic value if that supports
hi where can i change this?
In the search value field of vlookup …click on plus and open in advanced editor then give
And in the output field which ever variable is used in svae for later …change the dtatype to generic value
hi where do i need to write the string?
Try like this
Hope this helps
hi for the output how? this is mine
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
yes in same excel, so i did not need to change anything right?
Input you need to change as above …in output use as is
hi i have try but the vlookup is not cpatured but it can run successfully
That depends on the value and the column type you supply