Getting error in vlookup in Excel

Help StudioX
,
1

Simple vlookup i am getting below error. But I have same in other process, surprisingly that is working fine.

VLookup: TypeConverter cannot convert from System.String.

Solution should be without use variable. Anyone please help.

2

@ujjalghosh

Can you please show what you are trying…

As per error looks like a datatype issue

Cheers

3

Here is the data
image

Now I want to get the User ID by vlookup
image

Here how I executed Excel Vlookup

image
image1332×841 38.2 KB

If you need any other details I will give you.

Thanks in advance.

4

@ujjalghosh

  1. May be the column type of Leavers ID is not same in both sheet please check
  2. SUserID can be of different type
    in value to lookup you can try CurrentRow.ByField("Leavers ID").StringValue

cheers

2 Likes
5

It works Thank a lot.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.