INDEX and MATCH Solutions
September
18
2025
(Thursday)
Time
08:00 AM PDT | 11:00 AM EDT
Duration: 90 Minutes
66 Days Left To REGISTER
Duration: 90 Minutes
66 Days Left To REGISTER
Instructor
Neale Blackwood
Neale Blackwood
The INDEX-MATCH combination is an advanced technique that can solve many look up problems.
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.
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.
Access Recorded Version
One Attendee / Group Attendees
Unlimited Viewing Recorded Version for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)