Excel - Lookups from X to V in 365

Name: Excel - Lookups from X to V in 365
Price: 49.00 USD
Availability: InStock
Rating: 4.5 (1200 reviews)

Price
$49.00 USD

Duration
0.3 Days

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Agenda

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.