YoVDO

Excel: Lookup Functions in Depth

Offered By: LinkedIn Learning

Tags

XLOOKUP Courses VLOOKUP Courses HLOOKUP Courses

Course Description

Overview

Master some of the most powerful lookup functions in Microsoft Excel, including VLOOKUP, INDEX, XMATCH, and XLOOKUP.

Syllabus

Introduction
  • Introduction
1. Locating Data with MATCH, INDEX, and XMATCH Functions
  • Locate data with the MATCH function
  • Retrieve information by location with the INDEX function
  • Use the MATCH and INDEX functions together
  • Use the new XMATCH function: Expanded and improved MATCH
2. VLOOKUP, HLOOKUP, and XLOOKUP
  • Structure data for use with lookup functions
  • Find approximate and exact matches with VLOOKUP and HLOOKUP
  • Use the new XLOOKUP function for exact matches
  • Use the new XLOOKUP function for approximate matches
  • New and expanded capabilities using XLOOKUP
3. Finding Matching Data without Using External Lists
  • Find table-like information within a function using CHOOSE
  • Use the SWITCH function for formula-embedded selection
4. Other Functions with Lookup Capabilities
  • Extract and count unique entries from a list using the UNIQUE function
  • Filter data and return matching records with the FILTER function
  • Use the SORT and SORTBY functions to create new lists
  • Use INDIRECT to return references specified by text strings
Conclusion
  • Next steps

Taught by

Dennis Taylor

Related Courses

Excel: Data Validation in Depth
LinkedIn Learning
Excel for Accounting
LinkedIn Learning
Excel Power User Challenge
LinkedIn Learning
Excel: Tracking Data Easily and Efficiently
LinkedIn Learning
Excel: VLOOKUP and XLOOKUP for Beginners
LinkedIn Learning