Referencing worksheet tabs 1

[rbygo]

Several months ago, DaleWatson123321 provided me with the solution

@@(A1&":J4&quot

to the following question which I posted in the Lotus Smartsuite forum. This formula works perfectly in Lotus. When I saved the file to Excel, all other formulas appeared to convert successfully, but not this particular one. I would be most grateful if Dale or someone else can give me the equivalent formula for Excel. The question was:

I have thirteen worksheet tabs in one file - one tab for each month, plus one worksheet tab that analyzes data from the current month. The worksheet tabs are labeled as follows:

JAN
FEB
MAR ...(etc, through DEC)
ANALYSIS

ANALYSIS cell A1 contains the name of the current month (in the same format as the monthly worksheet tab names.)
In ANALYSIS, I want cell B8 to pull in the contents of cell J4 from the current month worksheet tab, based on the month that is in ANALYSIS cell A1.

How do I structure the formula for ANALYSIS cell B8?

 

[GlennUK]

Use this formula ...
=INDIRECT(A1&"!J4&quot

easy as that.

Glenn.

 

[rbygo]

Thanks, GlennUK! For some reason, the formula was automatically converted to

=INDIRECT(A1&":J4&quot

(a colon instead of an exclamation point before the final cell reference). Changing the colon to an exclamation point did the trick.