Concatenating a cell address


N

nebb

Let's say cell B5 on a worksheet contains the name "Bob". If, in cell
B10, I were to enter '=B5' , the contents of cell B5, or 'Bob'
would appear in cell B10.

Now, in cell A1 of the worksheet, I have the number 5 and in cell A2 I
enter the following:
=concatenate("=B",A1)
Cell A2 would now contain the term '=B5', not the contents of cell B5.
Is there a function that would allow me,after doing the concatenation,
to have the cell show the contents of the constructed cell address?
 
Ad

Advertisements

Ad

Advertisements


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

IF function says too many nested 1
Concatenate or not? 4
Variable Sumproduct Range 6
Excel function - countif 2
Opposite direction 9
Cell variable in formula 1
Cell referencing 1
Help with function 2

Top