using cell value as part of worksheet name

[greg]

I need to know how to use a cell value as part of
worksheet name in a formula. I have a number in column A,
and want to use it as an index for the worksheet name.
Example: run number in column A, average value from cells
d2 thru d4 (from another worksheet) in column B. So
something like "=average('sheetname|A1'd2:d4)". The other
worksheets all have a common prefix with a number at the
end.

 

[Peo Sjoblom]

Try

=AVERAGE(INDIRECT("'Sheetname"&A1&"'!D244"))

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom