Hi,
I am using 'Sheet 1' of a workbook and would like to return the value in cell 'C3' from 'Sheet 2'.
Every time I add a line in 'Sheet 2' the formula in 'Sheet 1' auto corrects itself so that it now returns the value in cell 'C4' rather than 'C3'
Does anyone know how how to stop this happening so that it always return the value in cell 'C3' regardless of what changes have happened on that workbook.
Much appreciated.
Af
Last edited by afSE5; 10-13-2014 at 07:25 AM.
May be this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
HI
use "$" on both sides $C$3 on both side for absolute reference
Punnam
Thanks guys, the index function works perfectly.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks