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