UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Cell Referencing    
 
   
Coldbrain
post Oct 13 2005, 03:08 PM
Post #1

UtterAccess Veteran
Posts: 484
From: Florida
Okay I'm wondering if it is possible to create this type of cell reference..
A2=5
In C2, D2, and E2 I want =Sheet2!C5, =Sheet2!D5, and =Sheet2!E5
Is there any way to do it so that it is =Sheet2!C[A2], =Sheet2!D[A2], and =Sheet2!E[A2]
I know that doesn't work, but I think you get what I am trying to do..
Go to the top of the page
 
+
NateO
post Oct 13 2005, 03:15 PM
Post #2

Remembered
Posts: 5,055
From: Minneapolis, MN, USA
Hello,

Try the following:

=INDIRECT("Sheet2!C"&A2)
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 24th May 2013 - 07:23 PM