sheet name in formulas

S

starguy

if in a workbook a sheet name is "Names" and in another sheet naming
"Contact" cell A5 has text "Names". is there any way that if we type in
cell B5 of "Contact" sheet like this =A5!B5 and it return value of cell
B5 of sheet "Names".
i noticed this in some formulas but when i used, it did not function.
 
N

Niek Otten

=INDIRECT(A5&"!B5")

--
Kind regards,

Niek Otten

|
| if in a workbook a sheet name is "Names" and in another sheet naming
| "Contact" cell A5 has text "Names". is there any way that if we type in
| cell B5 of "Contact" sheet like this =A5!B5 and it return value of cell
| B5 of sheet "Names".
| i noticed this in some formulas but when i used, it did not function.
|
|
| --
| starguy
| ------------------------------------------------------------------------
| starguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=32434
| View this thread: http://www.excelforum.com/showthread.php?threadid=534459
|
 
Top