Using cell contents in formula

[Lee_S]

How can i use the contents of a cell inside a formula that references another cell on a different sheet.

ie, On my sheet the contents of A1 is "Myname". Now in cell B3 I want to use the contents of A1 in my sheet reference.

For example, instead of =Myname!C23

I want something like =A1!C23

Can it be done?

[Webtest]

By Jove, I think I've got it!:

=INDIRECT(ADDRESS(2,3,1,1,A1))

Parameters in order:

* row on other sheet
* column on other sheet
* reference type
* reference style
* cell on this (or any!) sheet that contains name of other sheet

Just look up "Address" in the HelpHeap.

This works in any cell on Sheet 1 with "Sheet2" in cell A1 of Sheet1 and "123" in Cell C2 of Sheet2. It returns "123" - the contents of Sheet2!C2.