Arithmetic Operations
March 23, 2022
Using PivotTables
March 23, 2022
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
Course ID Number: MSO-3002