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