Lookup Formulas
Master Excel lookup formulas including VLOOKUP, XLOOKUP, HLOOKUP, INDEX-MATCH, and more. Learn to retrieve data efficiently from tables and ranges.
Functions in this Category
Common Use Cases
Looking up values in tables
Generate formula for this →Two-way lookups
Generate formula for this →Dynamic range references
Generate formula for this →Approximate and exact matching
Generate formula for this →Cross-referencing data
Generate formula for this →Detailed Function Guides
VLOOKUP
Learn how to use VLOOKUP in Excel to search for values in a table. Includes syntax, examples, common errors, and tips for exact and approximate matchi...
Example:
=VLOOKUP(A2, B:D, 2, FALSE)Find exact match of A2 in column B and return value from column C
XLOOKUP
Master XLOOKUP, Excel's modern lookup function. Learn syntax, examples, and why XLOOKUP replaces VLOOKUP for more flexible data retrieval....
Example:
=XLOOKUP(A2, B:B, C:C)Simple lookup returning value from column C
INDEX-MATCH
Learn the INDEX-MATCH formula combination in Excel. More flexible than VLOOKUP, it allows lookups in any direction with better performance....
Example:
=INDEX(C:C, MATCH(A2, B:B, 0))Find A2 in column B, return corresponding value from column C
Related Formula Categories
Need a Custom Lookup Formula?
Describe your calculation in plain English and our AI will generate the perfect formula for you.
Try Formula Generator Free