Microsoft KB Archive/49264

{|
 * width="100%"|

Excel: Building A1 Style Reference in a Worksheet

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, versions 1.5, 2.2, 3.0, 4.0

-

SUMMARY
The following method requires Microsoft Excel version 1.5 or later. The INDIRECT function is not available in earlier versions of Excel.

The INDIRECT function can be used to build an A1 style reference on a Microsoft Excel worksheet.

For example, suppose cell A1 on the worksheet contains a C, cell A2 contains a 1, and cell C1 contains the word &quot;text&quot;, as follows:

  A1: C  B1:   C1:text A2: 1 B2:   C2:

To return the value of cell C1 (the word &quot;text&quot;), use the following formula:

  =INDIRECT(A1&A2) Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :