Make a formula that uses cell to pull data from sheet name that is same as cell.

[Dagoom]

Hello All,

I was wondering if it is at all possible to make a formula that references a cell to get a sheet name, then use that cell to reference a page?

Example

A12 = 1
A13 = 2

Pages in workbook

'1' & '2'

Can I make a cell that says ='A12'!D4*12? how would I go about this?

The next cell in the column would do ='A13'!D4*12

How would I go about this?

[benishiryo]

hi Dagoom. not sure if you meant it as to go to the Worksheet named "1" & take the value from D4, multiplied by 12? say if you were to reference it manually, would it look like this?
='1'!D4*12

if that's the case, then:
=INDIRECT("'"&A12&"'!D4")*12

[Dagoom]

Yes!

That is exactly what I wanted!

Now if only I knew how to make a formula for a column that ignored all values other than just the indirect A12.

Thanks a bunch, you have put me well on my way!