Calling Up Another Sheet
Key points
- Choose SHEET
- Enter the sheet name and the cell
- Copy it
In INDIRECT Builder you can build a formula that calls up a cell on another sheet.
Steps
- Choose SHEET
- Enter the sheet name and the cell
- Copy it
If you enter the sheet name as a cell such as A1, you can switch it by the cell text.
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.