Use the INDIRECT function to reference cells by their address

Use the INDIRECT function to reference cells by their address

Use the INDIRECT function to reference cells by their address

Syntax: INDIRECT(ref_text, [a1])

Step 1: Define the reference text (cell address) and optionally the A1/R1C1 style.

Step 2: Enter the formula in a cell and press Enter.

For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com