Description
Returns a reference to a range that is a specified number of rows and columns from reference cell[s].
NOTE
- OFFSET is a volatile function.
- The [rows] and [cols] arguments can be an integer or an array of integers.
- The [height] and [width] arguments can be an positive integer or an array of positive integers.
Syntax
Copied!=OFFSET(reference, [rows], [cols], [height], [width])
SAMPLE data
| | A | B | C | D | E |
|:---:|:----|:-------|:------|----:|:----|
| 1 | | | | | |
|-----|-----|--------|-------|-----|-----|
| 2 | | | | | |
|-----|-----|--------|-------|-----|-----|
| 3 | | Orange | Pink | 1 | |
|-----|-----|--------|-------|-----|-----|
| 4 | | Apple | Red | 2 | |
|-----|-----|--------|-------|-----|-----|
| 5 | | Lemon | Green | 3 | |
|-----|-----|--------|-------|-----|-----|
| 6 | | | | | |
|-----|-----|--------|-------|-----|-----|
| 7 | | | | | |
|-----|-----|--------|-------|-----|-----|EXAMPLE 1
Copied!//𝘰𝘧𝘧𝘴𝘦𝘵 𝘢𝘯𝘥 𝘦𝘹𝘱𝘢𝘯𝘴𝘪𝘰𝘯 𝘳𝘢𝘯𝘨𝘦: =OFFSET(B3, 1, 1, 2, 2)
| | A | B |
|:---:|:------|----:|
| 1 | Red | 2 |
|-----|-------|-----|
| 2 | Green | 3 |