OFFSET
Returns a value a set number of rows and columns from a starting cell.
How it’s written
OFFSET(start, rows, columns)Example
| A | B | C | |
|---|---|---|---|
| 1 | Code | Product | Price |
| 2 | P-10 | Lamp | 45 |
| 3 | P-20 | Desk | 210 |
| 4 | P-30 | Chair | 120 |
=OFFSET(A1,2,2)Result: 210
From A1, moves down 2 rows and across 2 columns.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
It recalculates constantly, so heavy use can slow a large workbook.
Practice it properly
VLOOKUP and INDEX/MATCH gives you real tasks, with your formulas tested on data you haven’t seen.