How to use vlooup activity


#1

Hello,

In uipath 2018.2 …they have provided vlookup activity…
Can anyone guide me with attaching sample workflow for same…
If i want fetch data from differnt sheet to first sheet how to acheive this???
It would be great help😃

Thanks.


#2

Lookup.zip (12.9 KB)

Try this.

Also go here for reference: https://activities.uipath.com/docs/lookup-data-table


#3

@CBlanchard
Can uipath Vlookup worked for two excel file.
Means I have data in 1st file and want to store result in 2nd file column using vlookup…
How to achieve this?


#4

Just so I understand a bit better what you want to do is this:

  1. Uipath loads up data from first excel file
  2. Uipath uses ‘vlookup’ to get a value from the second file using data from the first file

Or

  1. Uipath loads up data from first excel file
  2. Uipath uses ‘vlookup’ to get result from first excel file
  3. Uipath enters data into second file

?


#5

2nd situation…
@CBlanchard


#6

Try something like this.Lookup.zip (12.8 KB)

You can play with write cell, append range etc etc as to whatever you want to do :slight_smile:


#7

Ok i will try it and let you know if will face any issue


#8

@CBlanchard

fine…
but what if i want to use below formula
=VLOOKUP(Q2,$AE$3:$AF$10,2,TRUE)

please guide


#9

@CBlanchard

Please check attached files…in Lookup.xlsx , based on E3 to F10 column values ,
we have to calculate Bucket Column Value
by applying below formula using Uipath
=VLOOKUP(A2,$E$3:$F$10,2,TRUE)

lookup.xlsx (8.2 KB)
Output.xlsx (8.9 KB)


#10

Lookup.zip (13.8 KB)

Try this. Its a bit hacky, but it does the job.


#11

HI @CBlanchard, can you once explain the below screenshot seen while running the workflow ,

Thanks in advance.


#12

its trying to find the external file you linked.

go into your spreadsheet and update your values. Data > Connections


#13

OK @CBlanchard.