Webinars – LOOKUPs
The Alternative to the LOOKUP – Index and Match
Apart from VLOOKUP, INDEX and MATCH are the most widely used tools in Excel for performing lookups. The INDEX and MATCH combo is potent and flexible, and you’ll see it used in all kinds of formulas, from basic to very advanced.
However, while VLOOKUP allows you to perform lookups with a single function, INDEX and MATCH requires two functions, one nested inside another. Many users find this confusing, because they aren’t used to combining functions in Excel, so they avoid INDEX and MATCH.
This Webinar explains in simple terms how to use INDEX and MATCH together to perform lookups. It takes a step-by-step approach, first explaining INDEX, then MATCH, then showing you how to combine the two functions together to create a dynamic two-way lookup.
In this 60 Minute fast-paced learning session, you’ll learn:
- Lookup vs Index and Match
- Match Function
- Index Function
- Index and Match together
- Creating a 2-way lookup
Like this? Wanna see more webinars?
We have lots of different webinars on offer. To read more about them, click the button below.
Get in Touch
Would you like to discuss your companies requirements with us?
If so, please get in touch and we can organise a face to face zoom meeting at a time that suits you.
International: +353 85 133 5649
Ireland: (085) 133 5649