Cell Ref

[Matt]

Is it possible to Display in a cell, the cell reference
from where a value has come from?

 

[Jason Morin]

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

 

[Matt]

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?

 

[Stephen Dunn]

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.