YOU WILL NEVER PERFORM VLOOKUP AGAIN.. WATCH TILL END…

Рет қаралды 20,937

2 жыл бұрын

This video will teach you how to automate Vlookup in Excel with Python using the Openpyxl library. Increase your productivity by automating vlookup. Watch now and become a master of replacing Vlookup with Python automation using Openpyxl!

Пікірлер: 53

@mukeshkumarmahto767 Жыл бұрын

can we get the source code of this

@python-bits Жыл бұрын

You can find code here. pastebin.com/NjpRepNd

@MrKevin440 Жыл бұрын

Your tutorials rock! Everything use works as you describe and I wonder if you teach as your profession. Subscribed, liked, and bell! Awesome!

@yiprio4030 2 жыл бұрын

Thank you so much Your lesson is so good.

@kishorep3668 Жыл бұрын

Wonderful buddy , great video , I have been looking for such type of automation from 2018 but couldn't find, This one really helps 😀 , great job tons of thanks for the video .

@nandhagopal8699 2 жыл бұрын

Woww... really amazing.......I tried various area for 3 hrs ..not got what I want....but here...with only just this video I got it ..great... thanks a lot.....

@balrajswamy 2 жыл бұрын

Very nice Presentation and more clear, Thanks a lot sir

@radhikamadhavakumar5167 Жыл бұрын

Being a new python learner, this was really helpful and great explanation.

@hunnicutbj3124 2 жыл бұрын

Thank you, helpt alot!

@georgecodeing7907 Жыл бұрын

thank u so much ......exactly what im looking for :)

@pranjalpadole164 Жыл бұрын

Thank you soo much, it's helps me in my projects ❤

@csn572 2 жыл бұрын

Thank you.. Can you do this using arrays for both the sheets (master sheet and daily sheet). Please share if you have an example.

@ayandakhumalo7189 2 жыл бұрын

I love this.. Perfect Now can you make a video on Index/Match?

@haribhaskar72 2 ай бұрын

Awesome 👍

@diegolorenzo8712 3 ай бұрын

would be super appreciated videos for pivots and indexmatch also!

@gsammy5115 Жыл бұрын

Thank you very much🤩

@nikkikumari1701 2 жыл бұрын

Thank you 😊

@YazminAbat 2 жыл бұрын

thanks for saving us from excel misery

@manndipp Жыл бұрын

Thanks a ton

@ggapsang Жыл бұрын

Thank you so much. Very kind and great lecture.

@python-bits Жыл бұрын

Glad it was helpful!

@royalwinautomatedsoftware2985 2 жыл бұрын

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

@CBSE1902 6 ай бұрын

Perfect, bhai if we have 120+ columns then do you think that firstly we need to count the columns in excel...it's not the right way to do in industry level

@hugogonzalez8242 2 жыл бұрын

Nice. Very helpful.

@python-bits 2 жыл бұрын

Glad it was helpful!

@lakshyagaran2514 2 жыл бұрын

Hey, I am able to vlookup..... but on my mastersheet only the values are getting printed, not along with the column names. Is there anything I should do, Please help !

@Frank-si2jd Жыл бұрын

Very nice tutorial and the way you go back and forward between the code and explaining what needs to be done in the sheet and what the code is doing in the Excel-sheet is incredible helpful. Is there a way, to automatically put rows in order of date?

@python-bits Жыл бұрын

This may require some pre-processing but it's possible. I will add a short tutorial for this in next couple of days.

@Frank-si2jd Жыл бұрын

@@python-bits Thanks! Hope you can send me a short answer when you have it online. You are doing a wonderful job here and this is highly appreciated by us the viewers!

@python-bits Жыл бұрын

Just added a new video on sorting. Check it out here: kzfaq.info/get/bejne/edRhh7eCv5qzoJs.html

@Frank-si2jd Жыл бұрын

@@python-bits Hi Python Bits, thank you very much for your incredible fast response in creating this tutorial!! Well done!

@z.r.777 2 жыл бұрын

Good good good. But I'll personally go with Pandas instead

@sandeepgupta6526 6 ай бұрын

Thanks

@sandeepchavan1013 2 жыл бұрын

For heading is not printing in final shee

@giogobronidze7788 2 жыл бұрын

Thanks for the video. Could you please do the same thing but using pandas?

@thisisamitrathore 2 жыл бұрын

pandas will remove all formatting and formulas of the file.

@MainTeknoID Жыл бұрын

thanks gan

@svstyle560 Жыл бұрын

If there is multiple master excel data then how can i vlookup the data. Need your help on this.

@python-bits Жыл бұрын

You will need to create multiple worksheet objects like we did for daily_sheet and master_sheet and iterate over each one of them and run a comparison.

@siddharthtiwari1335 2 жыл бұрын

I am facing error in import openpyxl. Kindly suggest what shall I do.

@python-bits 2 жыл бұрын

Make sure to install openpyxl package using 'pip install openpyxl' before importing it.

@hritikmukati8621 5 ай бұрын

this will not going to work for large data set.

@NRAJ1966 2 жыл бұрын

please add code so as enable to copy and use

@python-bits 2 жыл бұрын

Will start adding them. Thanks for the feedback!

@dieglo90 Жыл бұрын

Nice, but using pandas seens to be easier

@NRAJ1966 2 жыл бұрын

beutifuly explained but code not included with video

@python-bits 2 жыл бұрын

Glad it was helpful!

@gustavohernandez7169 2 жыл бұрын

It works but if you use a 41k rows pfff!!!

@python-bits 2 жыл бұрын

If you have a large file, you can store data in objects (or other data structure, probably list of dictionaries), perform your logic operation and then save that compared data into new excel file.