Easy Question?

[msimone]

If I have the text "B2" entered into cell A1 and in cell B2 I have the value 5...is there anyway to construct a formula where I reference A1 but it calculates it as 5?

Essentially I want the formula to look at cell A1 and have it point to the value of B2 when I do my calculation. Is this poppycock?

 

[Domenic]

Try...

=INDIRECT(A1)

Hope this helps!

 

[msimone]

You're awesome! Thanks Domenic!

Another (probably) stupid question, can you use =INDIRECT across worksheets?

 

[Domenic]

You're very welcome! If A1 contains ''Sheet2'!B2...

=INDIRECT(A1)

Or, if A1 contains B2...

=INDIRECT("'Sheet2'!"&A1)

Hope this helps!