Lookups are part of almost every financial model, and the method you choose affects the quality of the model. This webinar compares the main lookup functions: LOOKUP, VLOOKUP, HLOOKUP and the newer XLOOKUP. For time-based tables we recommend LOOKUP over VLOOKUP and HLOOKUP, because the latter two have significant drawbacks. The session also covers the strengths and weaknesses of INDEX and MATCH, the combination many financial modellers prefer.
For worked examples in Excel, see our tutorial on replacing VLOOKUP and HLOOKUP.
What you will learn
- The strengths and weaknesses of LOOKUP, VLOOKUP and HLOOKUP
- What XLOOKUP adds
- How LOOKUP replaces VLOOKUP and HLOOKUP with more transparency and a lower risk of error, with live examples
- How INDEX(MATCH()) works and why many financial modellers choose it