INDEX and MATCH Solutions
Date:
Thursday, September 18, 2025
Time:
08:00 AM PDT | 11:00 AM EDT
Duration:
90 Minutes
More Trainings by this Expert
Product Id : 507508
Price Details
Live: One Dial-in One Attendee
Corporate Live: Any number of participants
Recorded: Access recorded version, only for one participant unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Corporate Recorded: Access recorded version, Any number of participants unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
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 should you 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