Excel: Building A1 Style Reference in a Worksheet

ID: Q49264


The information in this article applies to:


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 "text", as follows:


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


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


   =INDIRECT(A1&A2) 

Additional query words:


Keywords          : 
Version           : 
Platform          : 
Issue type        : 

Last Reviewed: March 15, 1999