Referencing a different tab within a formula

[VonGoodwin]

Hi All,

I know this is possible, as I have seen it done before, but I just can't remember how!!

I have a formula which reads "=October!J12", but instead of October, I want to be able to reference a cell, so that I can change the month within that cell, which will then pull the same cell from a different tab (i.e. November)

Thanks in Advance
Yvonne

 

[Jonmo1]

Welcome to the board..

Use INDIRECT

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

Where A1 contains the sheet name.


Hope that helps.

 

[kpark91]

Something like this?

=INDIRECT(A1 & "!J12")

Put October in A1.

 

[VoG]

Try

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

where A1 holds October.

 

[VonGoodwin]

Wow, thankyou for the quick responses, and it works perfectly... I did look at indirect, but just got confused... much appreciated