Mazars – welcome to our Digital Classrooms! We are opening our Digital Classrooms to individual registrations, making our world-leading financial...
Performing lookups is a critical part of most financial models, and knowing which method is best can significantly increase the quality of your models. This free webinar gives an overview of various lookup functions, including LOOKUP, VLOOKUP, HLOOKUP and the newer XLOOKUP. For time based tables we typically recommends LOOKUP over HLOOKUP and VLOOKUP, as the two latter have significant drawbacks. To complete the lookup puzzle, we will also be doing a deep dive into the pros and cons of the top picks of many financial modellers – the INDEX(Match()) function combination.
If you are interested in learning the most efficient way of looking up data from a table, you may enjoy this webinar.
This website cannot function properly without these cookies.
Analytical cookies help us enhance our website by collecting information on its usage.
We use marketing cookies to increase the relevancy of our advertising campaigns.