sheet name in formulas
 

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...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=534459

sheet name in formulas
 

=INDIRECT(A5&"!B5")

--
Kind regards,

Niek Otten

"starguy" wrote in message
...
|
| 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...o&userid=32434
| View this thread: http://www.excelforum.com/showthread...hreadid=534459
|