OS-MSO-3002 Using XLOOKUP

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