Every Excel user knows that VLOOKUP is a tricky function to manage, but there are alternatives few people are aware of. This session will explore the other lookup functions on offer including HLOOKUP, INDEX, MATCH and for Microsoft 365 users XLOOKUP. We look at the pros and cons of each so that you can confidently use the right one for your particular circumstances. Intermediate level.
