| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return cell reference as text
Looking for a formula that will allow me to return a reference used in
another cell as text. For example cell tab1!A1 contains formula =tab2!c1 and displays contents of tab2!c1 I'd like cell tab1!b1 to display "=tab2!c1" as text |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return cell reference as text
Received an answer to this question in 2nd posting on 8/21/07 "Show cell
reference as text". Thanks Ron Rosenfeld. http://www.microsoft.com/office/comm...f-9073b94362a5 "tjc" wrote: Looking for a formula that will allow me to return a reference used in another cell as text. For example cell tab1!A1 contains formula =tab2!c1 and displays contents of tab2!c1 I'd like cell tab1!b1 to display "=tab2!c1" as text |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return cell reference instead of text from within lookup() functio | Excel Worksheet Functions | |||
| Return cell reference instead of value | Excel Discussion (Misc queries) | |||
| Return value in cell above the reference | Excel Discussion (Misc queries) | |||
| GETPIVOTDATA - return cell reference, not value | Excel Worksheet Functions | |||
| Return cell reference of lookup value | Excel Worksheet Functions | |||
Linear Mode
