M Matt Aug 15, 2003 #1 Is it possible to Display in a cell, the cell reference from where a value has come from?
J Jason Morin Aug 15, 2003 #2 You can use the shortcut: <Ctrl><`> to display formulas. The "`" is the accent grave and can be found to left of the 1 key on your keyboard. HTH Jason Atlanta, GA
You can use the shortcut: <Ctrl><`> to display formulas. The "`" is the accent grave and can be found to left of the 1 key on your keyboard. HTH Jason Atlanta, GA
M Matt Aug 15, 2003 #3 What I meant was, if a value appears from a lookup, can I somehow show which cell it has come from in the cell next to it?
What I meant was, if a value appears from a lookup, can I somehow show which cell it has come from in the cell next to it?
S Stephen Dunn Aug 15, 2003 #4 Hi Matt, If your lookup was something like: =vlookup(a1,c1:e50,3,0) This would get the cell address: =address(row(c1)-1+match(a1,c1:c50,0),column(c1)-1+3) Use the help files for further information on these functions. HTH Steve D.
Hi Matt, If your lookup was something like: =vlookup(a1,c1:e50,3,0) This would get the cell address: =address(row(c1)-1+match(a1,c1:c50,0),column(c1)-1+3) Use the help files for further information on these functions. HTH Steve D.
