Concatenate - Can it pick up a cell reference from a formula?

[mbetsy]

My formula is =concatenate(A15,B15,C15) which I enter directly by typing "A15" "B15" etc.
I would like to create a concatenate that picks up the row number from another cell. Is this possible?

This is clumsy but it is the only way I can conjure how to explain:

Desired =concatenate(A(go get the value from cell A1)),B(go get the value from cell B1))
Cell A1 = value is a whole number, say 23
Cell B2 = value is a whole number, say 35

Apologies for the lack of pro language, I struggled with how to explain.

Tks.

 

[Joe4]

Use the INDIRECT formula when building cell references dynamically, like this:

=CONCATENATE(INDIRECT("A" & A1),INDIRECT("B" & B1),INDIRECT("C" & C1))

 

[mbetsy]

Hi Joe4 and thank you. That sure does work perfectly.

I understand formulas better when I can use common language in my head to recite to myself as I enter the technical terms of the formula. For example when I enter concatenate, I use the sentence "Combine A1 then B1 then C1". How would I recall this formula as the "indirect" needs a common translation in my head.

Tks.



/mbetsy

 

[Joe4]

Build the cell reference you want by formula, then wrap it in an INDIRECT function in order to tell Excel that it is a cell reference, and not a string.
See if this helps explain it in more detail: http://www.contextures.com/xlFunctions05.html

 

[mbetsy]

Thank you once again. I will head over there and learn.

 

[Joe4]

You are welcome.