Variable determining formula

N

natelr

=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!
 
F

Franz Verga

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!
Click to expand...


=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
 
Top