Excel Vlookup

Help
1

Hi All ,

I have one vlookup formula but i m not able to understand it.
=VLOOKUP(Q7,$AE$3:$AF$10,2,TRUE)

Can u please help me with this.

Regards,
Sagar.

2

and how can i use this using Uipath for excel processing

3

Here Q7 is the cell name, which is the value ur looking for in the table,
$AE$3:$AF$10 - is range of the table, in which u will be looking for value. In your example your looking for Q7 value in AE column.
2 means if Q7 value found in AE column, it will return corresponding value from 2nd column(ie AF coulmn value, it will consider AE as first coulmn)

TRUE - means it will check Approximate value in AF column

1 Like
4

Please refer to the below.

3 Likes
5

can you please elaborate that range section
I cant understand that $AE$3:$AF$10 …

6

@SagarSB In below image i marked in red line those cells are considered as range in your example. In this table range all vlookup operations takes place.

Capture

1 Like
7

Thank you

8

how can i use this formula using Uipath

9

Please help me to use same formula by using Uipath

10

@SagarSB i used different set of excel for operations. u can change range and try with ur values. Find below files.

vlookup----.xaml (6.7 KB)

Book1.xlsx (8.2 KB)

1 Like
11

@Manjuts90
Can you please provide workflow for following situation:
As u have used same excel file for vlookup.
If we have two files Book1 and Book…
Book1 is having data as u r file contains but we want to store result into another file Book2 using vlookup…
How can we acheive this using uipath

12

@SagarSB try below workflow for different workbook.

vlookup----.xaml (7.0 KB)

1 Like
13

@Manjuts90

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)

14

@SagarSB try below one. In write cell give path of workbook location

vlookup----.xaml (10.5 KB)

Try this and let me know

15

@Manjuts90

After running workflow output.xlsx opening empty.

OutputError
OutputError1022×571 2.41 KB

16

@SagarSB retry once again and if same thing happens share ur workflow

17

ok i will let u know
@Manjuts90

18

is it right path
“=VLOOKUP(A2,‘C:\Users\P\Desktop\UiPath\Lookup.xlsx\Sheet1’!$E$4:$F$10,2,TRUE)”
@Manjuts90

19

try as below

“=VLOOKUP(A2,‘C:\Users\P\Desktop\UiPath[Lookup.xlsx]Sheet1’!$E$4:$F$10,2,TRUE)

20

Ok let you know.
Thank you