Donate SIGN UP
Home > Technology > Microsoft Excel Formula problem?

Microsoft Excel Formula problem?

Avatar Image
Kelvin | 16:01 Sun 24th Apr 2005 | Technology
3 Answers
I want to write a simple formula in microsoft excel which references a particular cell in a different worksheet. However, if the location of the referenced cell moves, due to the insertion of a row or column for example, I don't want the formula to 'follow' the cell so the value stays the same, but continue to reference the original cell position. I've tried making the referenced cell an 'absolute reference' using dollar signs but this only applies if the cell containing the formula moves, not the reference. Any Ideas??
prev Windows XP Startup Issue
  
next Computer Fault
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by Kelvin. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image kempie

Try this formula

=INDIRECT(ADDRESS(1,1,1,TRUE, "Sheetname"))

where 1st no. is the row no. of referenced cell

and 2nd no. is column no.  e.g. A=1  B=2  C=3  etc.

16:58 Sun 24th Apr 2005
Avatar Image kempie

Silly me you can just use INDIRECT with your cell reference in quotes

=INDIRECT("Sheetname!B3")

17:06 Sun 24th Apr 2005
Avatar Image Kelvin
Question Author

Kempie you are a genius, technological as well as financial!!!

18:38 Sun 24th Apr 2005

1 to 3 of 3rss feed

Do you know the answer?

Microsoft Excel Formula problem?

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.