Answer:
The offset function
Step-by-step explanation:
In Microsoft Excel, the offset function or formula returns reference to a particular cell.
The syntax is:
= OFFSET(reference, rows, cols)
Where:
reference = the base cell
rows and cols are the direction to move
For instance:
OFFSET(A1, 3, 1) will return cell B4
Because:
3 will shift down the reference from A1 to A4
1 will shift right the reference from A4 to B4
