indirect

  • Thread starter Thread starter peter
  • Start date Start date
P

peter

Hi,
name a range fred1 that refers to =$a$4 and
any cell that has =fred1 returns a4's value.

if you are in cell c4 and you name a range
fred1 that refers to =$a4 then
any cell that has =fred1 returns the cell
value that is in col a and on that row.

But, if you enter into cell c4, =indirect("fred1")
it returns the value in A1 not A4.

Any way to get indirect to return the value in a4???
I need to separate the 1 from fred so that I can evaluate
=indrect("fred" & b1), where b1 holds the value 1.
peter
 
Peter,

When you define fred1 as $A4, you are defining it relative to the row you
are in, so if you are in row 1 when you define it, you are saying fred1
refers to column A, 3 rows on. Go to row 16, and it will pick up A19.

To get what you have to ensure fred1 is an absolute row and absolute column
referred name.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top