Lookup and Reference Formulas
Practice 14 Excel lookup and reference formulas like VLOOKUP, XLOOKUP, INDEX, MATCH, and OFFSET with interactive exercises. Retrieve data and connect datasets efficiently.
Address Coordinate Cell Reference Formula
Learn how to construct cell addresses and evaluate dynamic text references in Excel using ADDRESS and INDIRECT. Build dynamic sheet pickers and flexible models.
Choose Index Selection Formula
Learn how to use CHOOSE in Excel to model financial scenarios, map fiscal quarters, and build dynamic formula switchers without lookup tables.
Formulatext Formula Inspection Tool
Learn how to display live formula syntax as text strings in Excel with FORMULATEXT. Build audit documentation tables and inspect calculation logic instantly.
Hlookup Horizontal Data Lookup Formula
Learn how to search horizontally across columns in Excel using HLOOKUP. Pull quarterly targets, tax tables, and understand row index rules cleanly.
Hyperlink Clickable Link Formula
Learn how to create clickable links in Excel using the HYPERLINK formula. Navigate internal sheets, open intranet files, and launch pre-filled emails cleanly.
Index & Match Two-way Matrix Lookup
Learn how to combine INDEX and MATCH in Excel for flexible lookups. Perform left lookups, two-way matrix grid intersections, and dynamic row-column searches.
Match Relative Coordinate Lookup Formula
Learn how to locate items and find relative row or column positions in Excel using MATCH. Learn exact, greater-than, and less-than match types cleanly.
Offset Dynamic Range Reference Formula
Learn how to construct dynamic ranges in Excel using OFFSET. Build rolling 3-month averages, flexible financial models, and understand volatility risks cleanly.
Row & Column Coordinate Formulas
Learn how to generate dynamic row numbers, inspect column positions, and count table dimensions in Excel with ROW, COLUMN, ROWS, and COLUMNS.
Vlookup Vertical Lookup Formula
Learn how to use VLOOKUP in Excel to search catalog tables, pull product pricing, and understand exact vs approximate match without column index errors.
Xlookup Modern Lookup Formula
Learn how to use XLOOKUP in Excel to look up left, return multiple columns, handle missing data natively, and eliminate column index errors forever.
The lookup path is the core of data relationality. We move beyond simple VLOOKUP to learn XLOOKUP and dynamic array referencing, enabling you to build scalable, interconnected data models with zero manual friction.
You'll learn exact formula syntax to handle complex data retrieval scenarios, including multi-criteria lookups and horizontal referencing, transforming how you manage and link disparate datasets.