Using Indirect Formula In Excel To Create References

Asked By Scott P Daniels 50 points N/A Posted on - 06/09/2017

Hello, I am learning MS Excel for the first time. I do not know how to use the indirect formula in Excel to create a reference to a different worksheet. Could you help me, please? Thanks in advance.

• Status: Open
• Question Views: 269
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: Excel | indirect formula

Answered By Moss Baynes 0 points N/A #298994

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”.

About Moss Baynes

Questions
0

Answers
3

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/09/2017
• Question Category: MS Excel