Skip To Content
Course

Using XLOOKUP JC-MSO-3002

Self-paced

$15 Enroll

Full course description

Course Description

The XLOOKUP function enables you to look up information in an Excel spreadsheet. It is especially helpful when you are working with a large amount of data. Visually scanning a list to find information takes time, and you might miss the information you are looking for. Using a function speeds up the process and makes it more accurate.

By the end of this course, you will be able to:

  • Explain the purpose of the XLOOKUP function
  • Define the terms lookup value and return value
  • Describe how data must be arranged for the XLOOKUP function to work correctly
  • List the syntax of the XLOOKUP function
  • Explain how to use the XLOOKUP function's arguments

Estimated completion time (hours): 1.4