auto cell & sheet referencing

[scottwilsonx]

Hi guys & girls, hope someone can help me with this quandry:

I have a row of data showing different months, eg: A2 contains "Apri
2004", A3 = "May 2004" etc
I want to include this text in a formula below that automatically goe
to the worksheet with that name (eg: April 2004) and takes the value i
the appropriate cells down the column.
For example, the formula would say ='April 2004'!$I7 and take the valu
in I7 from worksheet April 2004.

Is there a way of including an automatic reference to April 2004 etc i
a formulae.

Many thanks for any help.

Scott

 

[Frank Kabel]

Hi
try
=INDIRECT("'" & A2 & "'!I7")

 

[scottwilsonx]

Frank, thanks, works perfectly.

Scott