Floating Relative Cell References???

[duhgman]

I have the following cell contents:

='SalesFigures'!A49 Sales - 49
='SalesFigures'!B49
='SalesFigures'!C49
='SalesFigures'!F49
='SalesFigures'!H49
='SalesFigures'!J49

The number 49 is the number of "sales" closed

Is it possible that when I close 2 more sales, to change the number above to 51 and have all the references automatically change to A51, B51, etc....

 

[PaddyD]

yes. for more details on the answer, provide more details about the context of your problem etc.

 

[SIXTH SENSE]

hi!
try indirect function.
=indirect("'salefigures'!A"& G1)
where G1 houses the close sales number.

 

[PaddyD]

index() would be preferable, given the volatility of indrect():

index(salesfigures!a:a,g1)

 

[duhgman]

Thanks,

The INDIRECT function with the & symbol did the trick!