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

Learn all about xlookups, vlookups, hlookups and their limitations.
👉 Take our Excel Course: https://www.careerprinciples.com/cour...

🆓 DOWNLOAD the Free Excel file for this video: https://view.flodesk.com/pages/62ed12...

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/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS

SOCIALS:
📸 Instagram - https://www.instagram.com/careerprinc...
🤳 TikTok -   / career_principles  
🧑‍💻 LinkedIn -   / careerprinciples  

GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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.