Excel - Lookups from X to V in 365

A one-hour live class on lookups in Excel 365, from VLOOKUP to XLOOKUP, including error handling and combining functions.

1 hourIntermediate1 modules

Overview

About this course

A one-hour live class on lookups in Excel 365, from VLOOKUP to XLOOKUP, including error handling and combining functions.

Curriculum

1 modules

Compare two lists with VLOOKUP and hide #N/A errors with the IFNA function.
Combine VLOOKUP and CONCAT to locate values based on multiple columns and use wildcards with VLOOKUP to retrieve information based on a partial match.
What is XLOOKUP? - Learn about the new XLOOKUP function and how to use it for vertical lookups.
Use XLOOKUP to Return Two or More Values - Learn how to use XLOOKUP to return two or more values.
Use XLOOKUP for a Horizontal lookup - Learn how to use XLOOKUP for a horizontal lookup.
Use XLOOKUP Match Modes - Learn how to use XLOOKUP match modes.
Use XLOOKUP Search Modes - Learn how to use XLOOKUP search modes.
Use XLOOKUP for a Two-Way Lookup - Learn how to use XLOOKUP for a two-way lookup.
Use XLOOKUP to Compare Two Lists - Learn how to use XLOOKUP to compare two lists.

Who it's for

Excel 365 users who match data across lists.

No formal prerequisites. Bring curiosity and a willingness to practise.

Microsoft Office & 365 Apps

Microsoft Office & 365 Apps

Microsoft Office & 365 Apps

Microsoft Office & 365 Apps

Microsoft Office & 365 Apps

Microsoft Office & 365 Apps

Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.