Lookup Functions — VLOOKUP, XLOOKUP, and INDEX MATCH

In this lesson, we will learn lookup functions in Excel. We will understand how to retrieve information from another table based on an ID, code, or key value using VLOOKUP, XLOOKUP, and INDEX MATCH through practical examples. ## Lesson objective In this lesson, we will learn lookup functions in Excel. In the previous lesson, we covered Date and Time functions. We learned how to use , , , , , , , , and for date-based analysis. Now we move to one of the most important data analysis topics in Excel: lookup functions. In real work, data is often not complete in one table.