Question

J

Just Merks

Seems a simple question, but I do not have a clue.

Assume in Cell A1 "= A2".

Now I want to reffer the two with a value which is in A3. Which can vary.

Something like "=A(A3)"

Is that possible?
 
C

Claus Busch

Hi Just,

Am Fri, 22 Jul 2011 20:43:00 +0200 schrieb Just Merks:
Assume in Cell A1 "= A2".
Now I want to reffer the two with a value which is in A3. Which can vary.
Something like "=A(A3)"
Click to expand...

try:
=INDIRECT("A"&A3)


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average Question 2
Copy & Paste 1
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Excel - Wich Function should I use? 1
Data Validation and drop-down list using IF, AND and what else? 8
Markup status / dashboard 0
Dynamic pointing to a cell 0
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3

Top