Replace your VLOOKUP. Use THIS instead!

Рет қаралды 6,936

Күн бұрын

👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
Ever wondered how to do the good old VLOOKUP from Excel in Python? In this video, I'll show you how Python isn't just an alternative but can actually be a game-changer. No jargon, just a simple guide on making data matching and merging easier and more flexible. If you're familiar with Excel's VLOOKUP and curious about what Python has to offer, this one's for you. Dive in, let's learn something cool together!
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
0:00 - Introduction
0:22 - Traditional VLOOKUP
1:46 - Python Alternative
6:03 - Outro
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Data Visualization Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-tem...
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: / sven-bosau
📸 Instagram: / codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation

Пікірлер: 23

@CodingIsFun 9 ай бұрын

*Heads up:* This solution uses the new "Python in Excel" feature in Microsoft Excel 365. It's now available for Enterprise, Business, Education, and Personal users on the Windows Beta Channel. It will launch first on Excel for Windows starting with Version 2309 (Build 16818.20000). So, if you don't see the new Python feature, make sure you're in the Beta Channel and keep checking for updates.

@matixzz959 6 ай бұрын

Dude i've been learning a lot from you and your videos, keep it up and ty so much.

@CodingIsFun 6 ай бұрын

Happy to hear that! :)

@patriciohernandezballester2485 9 ай бұрын

Sven always meets the standard, thank u so much for your amazing work that also hits the nail in the head

@CodingIsFun 9 ай бұрын

Hi Patricio. Happy to see you again in the comments! 🤩 As always, thanks for watching and your kind words - I appreciate your support! 🙏

@clay4gli 9 ай бұрын

Wow - how have I missed your channel up till now. Great content!

@CodingIsFun 9 ай бұрын

Happy to hear that you found my channel! :)

@ermalgashimramori 9 ай бұрын

Thank you very much Sven, the thinking when working between merge and vlookup is different and your explanation was superb.

@CodingIsFun 9 ай бұрын

Glad I could help! Thanks for watching and taking the time to leave a comment. I appreciate it! 👍

@barcode6495 9 ай бұрын

This is a good video. Is a reconciliation shows what is on one list that is not in the other and viceversa

@CodingIsFun 9 ай бұрын

Thanks for watching. Glad you liked the video! :)

@lozerkit4949 9 ай бұрын

You are so advanced ❤

@CodingIsFun 9 ай бұрын

Thanks! 👍

@goutamnayak5011 9 ай бұрын

I want to make career in Data analyst profile so for this Should i learn ms Excel deeply all functions Or i can start using ai tools and copilot 365 for ms Excel works

@hamzasalhi2460 9 ай бұрын

Thank you for the tutorial amazing as always! but why I don't have access to Python yet in my Excel? I have been checking everyday

@CodingIsFun 9 ай бұрын

Thanks for watching. This solution uses the new "Python in Excel" feature in Microsoft Excel 365. It's now available for Enterprise, Business, Education, and Personal users on the Windows Beta Channel. It will launch first on Excel for Windows starting with Version 2309 (Build 16818.20000). So, if you don't see the new Python feature, make sure you're in the Beta Channel and keep checking for updates.

@hamzasalhi2460 9 ай бұрын

@@CodingIsFun Thank you for the reply I'm using the enterprise version paid for by my company but still don't see it I'll check the beta channel and see if they can opt-in or something

@goutamnayak5011 9 ай бұрын

I mean by is it still important to learn ms Excel all functions or I can do my all work by using copilot 365 in ms Excel 3:32

@CodingIsFun 9 ай бұрын

It's hard to tell from a distance since I don't know your background. But I'd say, start with basic Excel functions like SUM. VLOOKUP, etc. If you run into challenges, turn to Google, ChatGPT, or future tools like Microsoft Copilot. Knowing the basics and using AI for extra help is a good approach.

@HarshKumar-cl6qx 9 ай бұрын

Next please make a video on how to make a game or an app in streamlit that supports in game or in app currency where users can buy currency from our payment gateway and further use it to purchase in app items . I don't know if it's possible but I am still asking 😂

@CodingIsFun 9 ай бұрын

Thanks for watching and your suggestion.