=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
|