XLOOKUP in Excel 🙄 Level up in Excel in one hour!!! 💃🏼 You’re invited to a FREE LIVE Excel class with Miss Excel! 🎉 Register Now + Replay Access: https://lnkd.in/e4k6AZm4 🗓️ Date / Time: Tuesday, July 9 at 12pm ET 📕 Topic: Pivot Tables & Analysis 🗯️ Description: In this free LIVE 60-minute power-packed session, you will discover Miss Excel’s secret hacks to unleash the full power of Microsoft Excel! Miss Excel will share hidden tricks for optimizing your spreadsheets with Pivot Tables & Data Analysis to save you hours each week! ‼️ Reminders: EVERYONE who attends the event live will be receiving a bundle of practice files, completely for free! If you can't attend live, you will also get access to a 48 hour replay when you register! ✨ Once registered, remember to save the date into your favorite calendar app! 🍹 Have your computer and favorite drink ready! (This will be fun I promise!!!) 👯 Tag a friend to invite them too! 💃 Limited spots available! Make sure you register early. ❤️ and comment “Registered” below to let us know you will be joining us live! - #cheatsheets #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
We can use index+match also
Use vlookup
🔍 Helping Businesses Make 🚀 Data-Driven Decisions 👔 Founder at Datum Discovery 🏆 Corporate Trainer & Mentor (📈 Power BI, Data Analytics, Business Intelligence, Data Science) 🧑💻Power BI Consultant 🎓 IIM Calcutta
1wPivot Tables and Data Analysis are crucial for summarizing, analyzing, and extracting meaningful insights from large datasets. They enable users to quickly sort, filter, and visualize data, facilitating better decision-making and efficiency in data-driven tasks.