Cell Referencing Problem

  • Thread starter Thread starter Don R
  • Start date Start date
D

Don R

Greetings,
In excel 2000 I would like to be able to read in different values for AK into the following cell entry: ='Feb01-04'!$AK39
Stated another way, I would like to rewrite the above cell reference so that the value AK is read from another source cell.
For example I might type AX into source cell A1 and the above reference would change to ='Feb01-04'!$AX39

Any help would be appreciated.

Thanks,

Don Rist
 
Don,

You can use the INDIRECT function to do this. E.g.,

=INDIRECT("'Feb01-04'!$"&A1&"39")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


Don R said:
Greetings,
In excel 2000 I would like to be able to read in different
Click to expand...
values for AK into the following cell entry: ='Feb01-04'!$AK39
Stated another way, I would like to rewrite the above cell
Click to expand...
reference so that the value AK is read from another source cell.
For example I might type AX into source cell A1 and the above
Click to expand...
reference would change to ='Feb01-04'!$AX39
 
Try using Indirect.

=INDIRECT("'Feb01-04'!"&A1&"39")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Greetings,
In excel 2000 I would like to be able to read in different values for AK
into the following cell entry: ='Feb01-04'!$AK39
Stated another way, I would like to rewrite the above cell reference so that
the value AK is read from another source cell.
For example I might type AX into source cell A1 and the above reference
would change to ='Feb01-04'!$AX39

Any help would be appreciated.

Thanks,

Don Rist
 
Back
Top