This 1 day course is an intensive, hands-on training session designed to help participants master lookup functions such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH, and wildcard searches, while also incorporating error handling (IFERROR, IFNA)and conditional formatting for enhanced data analysis.

By the end of the course, attendees will:

• Understand how lookup functions work and when to use each one
• Apply lookups to retrieve and analyse data efficiently
• Troubleshoot common lookup errors using IFERROR and IFNA
• Enhance their reports with wildcard searches and conditional formatting
• Gain confidence in handling real-world datasets with practical exercises

This course is ideal for business professionals, analysts, and Excel users who want to improve their data management and reporting skills using lookup functions.

All attendees will receive a full course pack to refer to and will have the benefit of learning from a trainer with a wealth of experience in this area.

Course Content

Lookup & Reference Functions

• VLOOKUP – Advanced
• HLOOKUP – Similar to VLOOKUP but searches horizontally
• XLOOKUP – More powerful and flexible than VLOOKUP
• INDEX & MATCH – An alternative to VLOOKUP that offers more flexibility

Data Management & Cleaning

• Sorting & Filtering – Helps organize data before using lookup functions
• Removing Duplicates – Ensures lookup data is clean

Error Handling & Troubleshooting

• IFERROR & IFNA – Handle errors in case a lookup fails
• Common VLOOKUP Mistakes – Such as incorrect column index, range mismatches, and absolute vs. relative references

Dynamic & Advanced Lookups

• Using Named Ranges – Makes formulas easier to read
• Approximate Match Lookups – When exact values aren’t available
• Using VLOOKUP with Wildcards – Searching partial matches with * and ?
• Using Conditional Formatting to analyse and lookup datasets

Who should attend?

This course would be very relevant to anyone who uses LOOKUPs and wants a more advanced learning experience. Some of the typical attendees include finance professionals, data and business analysis, sales, marketing, HR, payroll, project managers, supply chain & logistics, administration, researchers, IT, Data professionals.  

Certification

On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course.

This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.

Cost

An ‘Early Bird’ discounted rate of €499 is currently available. This training course normal rate is €599. Places are limited and are allocated on a first come first served basis. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.