Yet another great video from Anders. These videos are nice and clear. He also goes over the content numerous times so that you get to see how it is done. After watching quite a few of the videos I can pre-empt the exact way that Anders is going to do it and also know the correct "coding". A sign of a great video and teacher that the content has sunk in and not one of those presentation videos where you are left guessing how to do it. Keep up the great work Anders !!!!!

With this video you just cleared a path for my Kaizen from a pitfall. Thank you!

Thanks for the video. Really amazing. So easy to understand.

Anders, need more UiPath videos....Plz.

This video is very good, easy & specific to understand the lookup activity using in UiPath. Thanks for sharing.

Always enjoy and learn from your videos!

good concept and neat and clean explanation.....keep up the good work Anders😊

Great tutorial. It's really helpful. Thanks

THANK YOU!

Thanks for your great tutorial!

Thanks!

Hi great videos. How can we take Excel data get it on a weblink and search for it on web and get result back in excel

Solid video. Thank you very much (:

all your videos are tutorial from each other.

Hi Anders, I have excel contains 1000 rows . Two columns Name, ID. Now I need to check string 'Madhu' in Name column and update value at ID column. Could you provide me solutions..

Great video! How can i loop from another excel workbook? Cos yours is from same excel workbook with multiple sheets

Hi Anders great video as always! I have few doubts regarding excel, is there a way to add macros to an xlsx file with UiPath? Imagine I have a VBA code stored in a textfile on my desktop, and I wish to convert that into a macro and install it inside of a ExcelWorkbook.xlsx, is it something UiPath is capable of? Also, imagine we have a macro enabled workbook, and I wish to retrieve a list of the macros present inside of it, is this possible?

Thanks good videos. The software is not that much practical.

Is there another way to lookup values? I'm working with a large amount of data and this method takes a lot of time executing I believe due to the loop.

Great video Anders, I'm trying to adapt it so it captures the result of the VLookup to a variable and then uses that value to search on a website. But is there a way that if a particular Element (Element exists) doesen't exist, it then goes back to the Lookup and then searches the next available column. So with my info it has the following: Product Code 1 Code 2 Code 3 Code 4 Case SAM012 SAM013 SAM014 Memory 32GB_SAM 64GB_SAM Screws M2_TORX M4_TORX M5_TORX M6_TORX The VLookup works perfectly and using predefined variables it will find M2_TORX from Column called 'Code 1' - it then takes this value and puts it into Amazon to see if it exists. But if the element does not exists, I want to do is for to search the next column and if it doesn't have the required element it then goes to Code 3...and if the element does exist, this loop terminates

Hi Anders. The course material is not accessible.

The name Lookup is a bit confusing here I guess, here it means a simple Search/Find. and we already have vlookup between sheets 👍

Hi Andres, I have a question. You have a Excel with IDs (A1:A5 )which when you use Read Range with For Each Row, that it opens a Page in Browser. In that page I use Data Scraping to get the data as Extracted Data Table. Is it possible to write Extracted Data Table in rows in Excel, for example from B1:F1, depending how many data you have in Extracted Data Table. If not, is it at least possible to write Extracted Date Table in a single cell? I read somewhere that VB.Join should do the trick, but I was unsuccessful in doing this. If you have a advice what I could do here, I'll really appreciate it. Kind regards

Hi Anders..Could you please help me to solve the below activity? Read given excel contains 4 columns. member name, age, amount and status Read excel and group all the rows with status as completed Group all rows with status as error Create two tabs in the same sheet as error and completed write the above group of rows to corresponding tabs and save the excel

Hi Anders, my requirement is 1 Lakh record with both excel sheet lookup.. If we use for each row it will take more time.. Any other method.. Please let me know

What is the version of studio x used in the tutorial?

What does it mean "gv" ?

Thanks a lot for all your support and kind words around the UiPath MVP process 😍 Check my best UiPath course (The Beginners Course 2021): kzfaq.info/get/bejne/qdZljdp3sMzMXWQ.html 🙂