UiPath Tutorial | Accurate VLookup in UiPath (2020) | Uipath Excel Automation | Uipath ExpoHub

You have covered a very commonly needed topic and explained in easy way...thank you!

Dear, I need a help on how to perform "Right Click" menu click operation in UiPath...on a system screen user list is there. I want to right click anywhere on the list and subsequently a menu will occur. From that menu I would like to click "Save All"... how to do that? Please advice...

Hey Rakesh, while doing this exercise I am getting the below error.
Lookup Data Table: Column 'Item' does not belong to table DataTable.
I am using look up value as - row("Item").tostring
Column name is "Item" in the excel sheet which I am using as a sample. There are no spaces as well . Not sure what could be the reason. Can you please advise.

how to make a write range after the first activity is finished using for each. thanks

Informative Video..Thanks.

if the range is Dynamic, then how we can manage to select, Please explain bro?

I don't understand what is explained here..Subject says Vlookup..But what is explained is 'lookup datatable'. UI path has something specifically 'VlookUp' to compare directly in excel spreadsheets..

In the write cell range, you can use an alternate method. Create a variable as count and set value as 2. inside loop create assign activity (count = count +1). In the write cell range "D"+count.tostring.

Very useful video. Thank you.

Do you have any suggestion on how to know the range of the DataTable, like the last cell ? For example, the table has thousands of rows and columns, it will may take forever to read if the range is set to " " only. So is there a way to know the last cell? Thank you.

Hi Rakesh,
First of all I am thanking you for your all Videos Useful for me and others too. Taking Learning Experience through you Videos...

Reg : RPA UiPath / Excel Activity /Lookup Function

I am having
1 Master XL Sheet
4 child XL sheet

Each Sheet Having 2 headers *SerialNumber(Column A) and *Status (Column C)

Target is:
At a time Need to update the master sheet based on the SerialNumber from 4 child Sheet *Status.

Current Status is :
After the studio Design , if I ran a single single Child Sheet na it's updating perfectly.
But
When I am using the whole child Sheet to update in master sheet it's only printing the SINGLE child Sheet *Status.

What it's doing na,, it's is removing the *status Of initially ran child Sheet Status....

Design for single Child sheet,
1 read Range of Master sheet ,
2 Read Range of Child Sheet,
3 For Each Row,
3.1 lookup Function
3.2 write Cell Activity.
Given Condition is
->> "C"+(DT1.Rows.indexof(row)+2).ToString<<-

Design for Whole Child sheet is Repeting the same design one by one in sequence ..

Finally it's show's single Child sheet status only......

It's updating a single Child Sheet only.

Please suggest me what I need to do...

Hi.. Can't we achieve the same using the join activity... and is using the join activity for this purpose better?

Thanks for knowledge very nice ,I want to know if I want vlookup for two columns how to do it

I had a issue, when i have 2 different "Customer ID" they duplicate the first row and don't insert the correct value.

Hi..very nice and informative video..thank u so much. I have one question. if we don't have a primary key present in DT2 for eg I have a sample excel workbook where there are 2 sheets: customers and phone. I want to copy the phone numbers from phone worksheet to customers worksheet. The primary key is customer id. When I ran this workflow a particular customer id was not present in the phone worksheet the phone number field in customer worksheet remains blank. But if we want to fill that field with message like "customer id not present in phone worksheet" can we use try catch. If yes when should we use it.Thanks again

Hi, your videos are clear to understand. I have one exercise, in an excel workbook i have dynamically varying sheets names and i need to read all the sheets in that work book also i have to read a particular column in the sheets which is having a unique color filled cell in that column (ex. Red), i need to get that cell value and search it in a pdf document having the same value on it. If i could identify the value in the pdf then i need to highlight the value in that pdf otherwise the tool should write it in a excel workbook that value is not available in the pdf for that cell value. Kindly help me to done that exercise.

Hi ..In the same example how can we extract multiple columns. Your feedback would be highly appreciated.

Very nice video, clearly explained, made my day, thank you so much

This perfectly captures both the functionality in excel (for those that need a refresher) and how to accurately complete it in UiPath. Fantastic job!!

Hi, i could run the flow however it is taking too long (100 cells for 1 hour) to lookup and transfer the data. Is it because of too many rows/cell to transfer or something else? i sheets has over 2000 rows, meaning to transfer 1 column data there will be over 2000 cells. Any way to speed up the process? Thanks

how to use vlookup for multiple columns.colud you give me the answer.

sir what I do for multiple columns target in lookup data table activity

muy buen video, lo explicas genial. Thank you!!

Suppose my Customer ID column in one of the excel is unordered. Will it still work?

Hi , Thank you so much for the sharing the video with us. Also can you teach , how to copy the extracted value inside the table rather than copying to excel column,

This video was a life saver for me, thank for such thorough explanation

Bro I did the same workflow but I am getting " column does not belong to the data table " error.

What is the version of Sutdiox used in this tutorial?

Is there another way to do lookups? I have large data and it takes a lot of time executing

You are indeed a life saver mate! Thanks alot!

Is possible to filter data in excel and vlookup for filtred data which are visible

Thanks for the video. It really helped me a lot.🙌🙌

Hi sir, I have followed you but it is taking too much time while running please tell me how can I reduce this time ? Please help me

Thanks for the clear explanation through out the video, I liked your brief description below every video and it was very helpful for me & also all.

Hi r u providing online course

Hi Rakesh it would be good if you include the excels in the discriptions

Really your explanation is excellent and easy, I benefited a lot
I have a question. I have two excel files as in the example, but they have five thousand rows, so vlookup it took a lot of time to execute, more than an hour. Is there a way to do the same function while reducing the execution time?

Hi i tried this but im getting entry key already exist error at the Write Cell step. Pls help

Hi bro,
Thanks for the video.
I having an issue while doing this activity, am not getting actual values, insted am getting sequence of the values from excel1.

Great video !!thanks for help

Helpful! Thank you 💗

Thank you so much for wonderful and informative video....👍👍😊😊

what to do if data is null?

Hello Sir i get this error
("Lookup Data Table: In the 'Target Column category' the value for argument 'Column Name' is not set or is invalid.")
please help me to resolve this

Thank you, can we use something else and then write a cell because it takes a lot of time.

Done😄

Great video! thank you!

Your videos help me alot i have a question that as we do vlookup i want to do xlookup, can you explain how should i do that .

Thank you so much for wonderful video, it's very helpful to get understanding of Excel module in detail in UiPath.