Using LookUp Data table Searching for data from 1st excel to fill 2nd excel column values

Help Activities
21

Do I need to open two excel files and then check manually ?

22

image
image1599×650 78.3 KB

This is the warning I am getting @ImPratham45 while checking manually

23

While applying formula in my 2nd excel sheet where the values need to be filled in the column J, it is not able to display the value i need. It is showing the below warning message

image
image1599×650 78.3 KB

24

First Try manually like you are doing on simple excel and if it works then use it in UiPath

25

Yes i guess

26

getting #NA bro

image
image1154×202 13.3 KB

27

That means there is no value found in lookup it is not error

28

image
image1682×723 59.3 KB

There are values in my Master excel file bro . I want to get both C6 and E6 values for D6 in this excel.

but I am just testing only with E6. I am getting #NA instead of Alcatel 1 1GB+8GB Black

29

You are using wrong formula my friend
Look
=VLOOKUP(A2,‘Sheet2’!A:C,2,0)

Here A2 is the value which is present in both the sheet it will be like primary key.
Then A:C is the range for master means it will search the value in A column of master and if it finds then will give you 2 means “B” columns value if you put 3 then it will give “C” column value

1 Like
30

Oh I see Thank you frnd. I will get back to you in a while. I will try this.

31

Yes you will get more idea if you google it

1 Like
32

So, the values(primary key values) that are present in column A of first excel file should be present in the same column A in 2nd excel file?

In my case the primary values present in first excel file are in column B
and the same primary key values present in 2nd excel file(Master data excel) are in column D.
And now I want to get lets say only E cell values from the master data excel file.

Can I apply the below formula
=VLOOKUP(B2,’[Article Master - Global.xlsx]Sheet1’!D:E,5,0)

33

No not necessary

34

Here pls make change at end as you want E value so from D:E here d,e i.e 2

1 Like
35

I have given like this as suggested.

image
image1247×214 17.2 KB

36

Yes ryt

1 Like
37

when I tried to press enter cursor is taking me to *'[C:* in the above screenshot

38

can you share both excels
Remove all data just keep 2-3 data so i will send you back

39

sure .

40

Book2.xlsx (2.1 MB) Test Master file.xlsx (62.1 KB) PLease find the two excel files for your reference frnd.

I want to get values(type & description) from master file and put it into I and J column based on primay key values ‘B’ in first excel file(Book2.xlsx)