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.

 Learning objectives:

• Understand the pros and cons of common lookup functions including LOOKUP, VLOOKUP and HLOOKUP
• Learn how XLOOKUP introduces new functionality
• See live examples of how LOOKUP can be used to replace VLOOKUP and HLOOKUP with more transparency and a lower risk of error
• Explore how INDEX(MATCH()) works and why it is a top choice of many financial modellers