Home » Posts

Increment cell reference with INDIRECT

To increment a reference created as text inside the INDIRECT function, you can use the CELL function. In the example shown, the formula in D5 is: =INDIRECT($B$5&"!"&CELL("address",A1)) Which increments as the formula is copied down.

April 14, 2025 · 1 min · 72 words · Dawn Morgan

Table of Contents

Note: both INDIRECT and CELL arevolatile functionsand recalculate with every worksheet change.

This can cause performance problems in more complex worksheets.

INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.

Excel formula: Dynamic worksheet reference

CELL Function

The Excel CELL function returns information about a cell in a worksheet.

The throw in of information to be returned is specified asinfo_type.

See below for a full list of…

Excel INDIRECT function

Excel CELL function

CELL Function#

CELL Function