Concatenate with results?

C

Cameron Smith

On Sheet 1 cell E4 contains the text Sheet2! and cell E5 contains the text
C42

On Sheet 1 in cell A2 I want to concatenate the contents of those two cells
so I get the reference Sheet2!C42 and I want A2 to contain what is on Sheet
2 in Column C and Row 42 rather than the text Sheet2!C42

How can I do this?

The reason I don't just have the Cell A2 reference Sheet2!C42 is that sheet
2 is a list and rows are added and deleted and sorted in different ways so
the content I want moves up or down and I am getting the correct row via
another means.
 
B

Bernard Rey

Cameron Smith wrote :
On Sheet 1 cell E4 contains the text Sheet2! and cell E5 contains the text
C42

On Sheet 1 in cell A2 I want to concatenate the contents of those two cells
so I get the reference Sheet2!C42 and I want A2 to contain what is on Sheet
2 in Column C and Row 42 rather than the text Sheet2!C42

How can I do this?
Click to expand...

=INDIRECT(E4 & E5)
 

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

Need Help with a VBA subroutine 0
Cell data entering slow! 0
Excel - Wich Function should I use? 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Macro to check if current cell value is 1 and previous cell was 0 6
Junp start my Select Case Macro 12
Array with many cells from a row but not in order or together 11
Macro beginner help with making tables 1

Top