Variable determining formula
 

=Sheet1!A10

how can I change this so the "10" is determined by data in another
cell.

So, say in some cell I entered "11" the formula would change to
=Sheet1!A11

Thanks!


--
natelr
------------------------------------------------------------------------
natelr's Profile: http://www.excelforum.com/member.php...o&userid=35839
View this thread: http://www.excelforum.com/showthread...hreadid=556267

Variable determining formula
 

Nel post
*natelr* ha scritto:

=Sheet1!A10

how can I change this so the "10" is determined by data in another
cell.

So, say in some cell I entered "11" the formula would change to
=Sheet1!A11

Thanks!


=INDIRECT("Sheet1!A"&B2)

where you can put in B2 10, 11 and so on.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

Variable determining formula
 

Great! Thank you so much.


--
natelr
------------------------------------------------------------------------
natelr's Profile: http://www.excelforum.com/member.php...o&userid=35839
View this thread: http://www.excelforum.com/showthread...hreadid=556267