treat cell contents as reference not value?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

What the the function I use to tell a formula to use the contents of a cell
as reference to another cell rather than a value in itself?

Example

Cell Contains
A1 Dave
A2 Andrews
A3 Evans
A4 A2

My Formula is

=A1&A4

I want it to return "DaveAndrews", not "DaveA2"

Possibly not the best example, but its simple I need it to treat the
contents of A4 as a reference rather than a value.

I've done it before but can't remember how
 
You are welcome! Thanks for the feedback!
Stefi


„Matt D Francis†ezt írta:
 
Back
Top