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
 
=A1&INDIRECT(A4)

Regards,
Stefi


„Matt D Francis†ezt írta:
 
You are welcome! Thanks for the feedback!
Stefi


„Matt D Francis†ezt írta:
 
You must log in or register to reply here.

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

Calculations 1
Help Creating Excel Formula 4
Using two Vlookup in one Cell 1
Creating a formula relating to several cells 2
Average formula where blank cells are counted as zeros 4
Locking a cell reference in a formula 1
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Factorial question 5

Back
Top