Sign up to save your podcasts
Or
Share VLOOKUP vs XLOOKUP in Excel: Lookup Functions for Financial Models (P2E5)
Share to email
Share to Facebook
Share to X
Share to email
Share to Facebook
Share to X
Or
VLOOKUP vs XLOOKUP in Excel: Lookup Functions for Financial Models (P2E5)
VLOOKUP vs XLOOKUP: which lookup function should you use in a financial model? This lecture covers VLOOKUP syntax and examples, the five limitations that can break your models, and why XLOOKUP is the modern standard.
In this episode:
- VLOOKUP syntax with tax-rate and scenario examples
- 5 VLOOKUP limitations that break models
- XLOOKUP syntax and advantages
- Scenario switches, reverse lookups and approximate matching
📖 Full blog post: https://modeloop.net/Blog/P2E5-Lookup-Functions-Demystified-From-VLOOKUP-to-the-Superior-XLOOKUP
📺 Watch the video lecture: https://youtu.be/QkJqPw0PQJ4
🎓 Courses: Excel for Financial Modelling | AI in Project Finance Modelling
🌐 modeloop.net
ModeLoop is hosted by Samir Asadov, CFA, ranked top 3 financial modeller worldwide (FMWC), with 15 years in M&A and project finance for renewables.
View all episodes
By Samir Asadov, CFAVLOOKUP vs XLOOKUP: which lookup function should you use in a financial model? This lecture covers VLOOKUP syntax and examples, the five limitations that can break your models, and why XLOOKUP is the modern standard.
In this episode:
- VLOOKUP syntax with tax-rate and scenario examples
- 5 VLOOKUP limitations that break models
- XLOOKUP syntax and advantages
- Scenario switches, reverse lookups and approximate matching
📖 Full blog post: https://modeloop.net/Blog/P2E5-Lookup-Functions-Demystified-From-VLOOKUP-to-the-Superior-XLOOKUP
📺 Watch the video lecture: https://youtu.be/QkJqPw0PQJ4
🎓 Courses: Excel for Financial Modelling | AI in Project Finance Modelling
🌐 modeloop.net
ModeLoop is hosted by Samir Asadov, CFA, ranked top 3 financial modeller worldwide (FMWC), with 15 years in M&A and project finance for renewables.