Vlookup problem using studio x

Help StudioX
,
1

image
image1053×366 24.1 KB

hi, anyone can help me on this regarding vlookup problem. im using studio x community

2

Hi @Nur_Amin

Make sure the string that you are trying to search in excel is string type.

3

hi can elaborate more on this?

4

@Nur_Amin

If you are looking for a string value then you have to pass the string variable in vlookup
If you are looking for a integer value then you have to pass the int variable in vlookup

It would be great if you provide the more information like about the value you are searching in the excel and what type it is.

5

hi book 1 is my data sample while excel file named vlookup is the value i want to lookup
Vlookup.xlsx (8.7 KB)
Book1.xlsx (8.6 KB)

6

Hi @Nur_Amin

Please check on this xaml

BlankProcess10.zip (77.5 KB)

Hope this helps!!

7

@Nur_Amin

Check this:
Vlookup.xlsx (8.7 KB)
Book1.xlsx (10.4 KB)
Sequence.xaml (12.6 KB)

image
image343×659 24.1 KB

8

hi i cannot open the workbook, im using studio x UiPath community version

image
image783×264 9.57 KB

9

Hi @Nur_Amin

Try this

VlookUp.zip (227.8 KB)

10

hi, i cannot open this workbook. im using studio x community version

11

Have you tried this? @Nur_Amin

It is working

12

@Nur_Amin

Check these:

image
image607×715 24.8 KB

image
image440×608 19.1 KB

13

hi, may i ask why u copy and paste ?
image

14

@Nur_Amin

Copying the sheet from excel1 to excel2

15

but u did not add sheet?

16

@Nur_Amin

After completing the process deleting that sheet

image
image336×847 59.4 KB

17

I tried to do the script using my real data but stuck in copy and paste as sheet 2 not exist because i did not add new sheet

18

@Nur_Amin

It creates new sheet as Sheet2 you no need to create the sheet in that excel

19

no need to add insert sheet?

20

Yes @Nur_Amin

Copy/Paste Range activity creates the sheet and add the data into that sheet