The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)

Video Description

Learn all about xlookups, vlookups, hlookups and their limitations. 👉 Take our Excel Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🆓 DOWNLOAD the Free Excel file for this video: https://view.flodesk.com/pages/62ed1285aeb3ce8812ee233c In this video you'll learn the pros and cons of the main lookup formulas. First, we'll go over the vlookup and where it can be useful. Then we'll look at the hlookup. Following this, we'll look at the main limitation of these two lookups, which is that it can only work if your data is the to right. As such, we introduce a solution in the form of an xlookup, going over 5 different scenarios where it can come handy, from easiest, all the way to hardest. 1. Basic xlookup 2. xlookup if not found feature 3. xlookup match mode 4. xlookup with multiple solutions 5. a nested xlookup (meaning 2 xlookups combined) Lastly, we'll go over the limitation of xlookups, and propose a complex solution involving a nested filter and sum formula. LEARN: 📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course 👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance 🏦 The Investment Banking Program: https://www.careerprinciples.com/career-track/the-investment-banking-program 🚀 All our courses: https://www.careerprinciples.com/all-courses ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬ Chapters: 0:00​ -​ Vlookup 1:50​ - Hlookup 2:53​ - Lookup Limitations 3:50​ - Xlookup Level 1 4:37​ - Xlookup Level 2 5:29​ - Xlookup Level 3 6:24​ - Xlookup Level 4 8:22​ - Xlookup Level 5 9:55​ - Xlookup Limitations Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.