Using Indirect Formula In Excel To Create References

Using Indirect Formula In Excel To Create References

The indirect formula in Excel has the following syntax: =INDIRECT (ref_text, [a1]) where ref_text is a cell reference or a text string. This ref_text creates the reference of the range. The [a1] stands for a Boolean TRUE/FALSE, which is used to determine the reference style of the selected cell.

Follow the steps to create a reference to cells from a different worksheet:

1. Name a worksheet as “Numbers” and enter integers in cells A1 to A10.
2. Open a different worksheet, and enter the sheet name “Numbers” in cell A2.
3. In another cell, type a cell name from “Numbers” which contains integers.
4. Write the formula for creating references in a separate cell:

=INDIRECT(“’” & A2 & “’!” & B2)

It creates a reference to cell B2.

5. Press Enter to see the value of integer in cell A2 of “Numbers”.