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