Microsoft Office & 365 Apps
Excel - Complex Lookups
A one-hour live class on advanced lookups: comparing lists with VLOOKUP, handling errors and combining lookup functions for harder problems.
1 hourIntermediate1 modules
About this course
A one-hour live class on advanced lookups: comparing lists with VLOOKUP, handling errors and combining lookup functions for harder problems.
Curriculum
1 modules
- Compare two lists with VLOOKUP and use IFNA and IFERROR to refine displayed results from a VLOOKUP.
- Combine VLOOKUP and CONCAT to locate values based on multiple columns and use wildcards with VLOOKUP to retrieve information based on a partial match.
- Create a combined index and match formula.
- Use the offset function with lookup functions.
- Return a formula as a text string from a given reference.
- Determine if specified cells contain formulas with the ISFORMULA function.
Who it's for
Excel users who match and combine data.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.