Overview
The INDEX-MATCH combination is an advanced technique that can solve many look up problems. The two functions are useful, but together they provide a range of solutions to common look up requirements.
Why you should Attend
Struggling to get your lookups to work?
Need more flexibility than XLOOKUP provides?
The INDEX and MATCH functions can solve many problems in Excel.
Areas Covered in the Session
- Learn the basics of the INDEX function
- See how versatile INDEX can be in solving problems
- Learn the basics of the MATCH function
- Discover how well they work together to solve look up problems
- Find out how they work with formatted tables
- See how to handle errors
- Learn how well INDEX works with dynamic arrays
Who Will Benefit
- Accountants and Finance Staff
Speaker Profile
Neale Blackwood is a Microsoft Excel expert with over 40 years’ experience as an Accountant and consultant. He has over 30 years’ experience using and writing about Excel. Neale has written over 250 Excel articles for the CPA Australia INTHEBLACK magazine since May 2002.
His first book, Advanced Excel Reporting for Management Accountants, was published in 2014 by Wiley.
He has presented over 450 live webinars on Excel since 2012.
Instructor
Neale Blackwood