Referencing sheet names in a formula

Posted by mark on October 29, 2001 6:12 AM

I have a model that has numerous datasheets supporting it. I would like to be able to have a cell that was referenced in the formula that would allow me to just type in the name of a datasheet and the formula would change.

Any help would be greatly appreciated.

Posted by Juan Pablo on October 29, 2001 6:15 AM

For example you want A2 to show Cell E4 of the specific sheet you want to. To do this put in A1 the name of the sheet, and in A2 put

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

That way you can change A1 and still get the "appropiate" result to show.

Juan Pablo