Showing a Cell Location as Text
Key points
- Choose ADDRESS
- Enter the row and column numbers
- Copy it
In INDIRECT Builder you can build a formula that gives a cell location as text from row and column numbers.
Steps
- Choose ADDRESS
- Enter the row and column numbers
- Copy it
The second formula gives the location as 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.