Return cell reference as text

T

tjc

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to return an address from a lookup into a table? 8
Automatically Pulling Cells from Different Tabs and Files 1
Lookup value and return with all related data 0
Need help changing focus between open forms 1
Average Calculations 11
complicate query? 3
Counting across tabs 1
Vlookup on blank cells formatted with dates 3

Top