Calling Up by Shifting
Key points
- Choose OFFSET
- Enter the cell and the shift
- Copy it
In INDIRECT Builder you can build a formula that calls up the cell shifted by rows and columns.
Steps
- Choose OFFSET
- Enter the cell and the shift
- Copy it
The second formula is a way that needs fewer recalculations.
Use "Build an INDIRECT Formula" (free)
Tools that go well with this
- Build a VLOOKUP or XLOOKUP Formula: Build VLOOKUP and XLOOKUP formulas.
- Build an IMPORTRANGE Formula: Build an IMPORTRANGE formula.
- Build an INDEX and MATCH Formula: Build INDEX and MATCH formulas.