formula reference in cell

  • Thread starter Thread starter wammer
  • Start date Start date
W

wammer

I have the number 7 in a cell. In another cell I want to reference cel
e7 (i.e. =e7). However, I want the number 7 in that reference to poin
to the cell with the 7 in it, so that I can change that and it wil
change the7 in the =e7. How do I do that
 
Assume 7 is in B1

=INDIRECT("E"&B1)

--

HTH

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