Excel Practice - OFFSET
Instruction
From reference B2, move 2 rows down and 0 columns to return the target cell reference.
Formula Syntax
=OFFSET(reference, rows, cols, [height], [width])
- reference: Base reference or reference text.
- rows: Number of rows to return/create.
- cols: Number of columns to return/create.
- [height]: Optional output range size.
- [width]: Optional output range size.
What it does
Return a shifted reference based on row/column offsets.
dynamic-array-data.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Category | Amount | Region |
| 2 | A | 120 | North |
| 3 | B | 340 | South |
| 4 | A | 560 | North |
| 5 | C | 225 | West |
| 6 | B | 90 | South |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use OFFSET with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.