Essential Lookup Functions
Lookup functions are the backbone of data analysis in Excel.
VLOOKUP
Searches the first column of a range and returns a value from a specified column.
XLOOKUP
Modern replacement with more flexibility and exact match default.
INDEX-MATCH
Powerful combination offering left lookups and dynamic column references.