Concatenating a cell reference
Posted by Ron on December 04, 2000 12:48 PM
I would like to build a cell reference by concatenating a letter and a number: if cell A1 = H and B1 = 28, I would like C1 to be equal to cell H28.
A B C
1 H 28
Can anyone help?
Thanks in advance,
Ron Pagano
Posted by Tim Francis-Wright on December 04, 2000 1:13 PM
The formula for C1 should be:
=INDIRECT(A1&B1)
HTH
Posted by Aladin Akyurek on December 04, 2000 9:51 PM
Tim probably meant to say
=CONCATENATE(A1,B1)
Aladin
Posted by Celia on December 05, 2000 1:59 AM
Or perhaps even :- =A1&B1
Celia
Posted by Ivan Moala on December 05, 2000 2:51 AM
I think Tim meant
=INDIRECT(A2&B2,1) which would give the result
referenced by H28 ??
Ivan
Posted by Celia on December 05, 2000 5:17 AM
What does the "1" in the formula do? Same as putting "true"?
Celia
Posted by Ron on December 05, 2000 5:44 AM
Thanks to all for your responses! The form
=INDIRECT(A2&B2,1)
worked great!
Ron
Posted by Tim Francis-Wright on December 05, 2000 7:15 AM
The (optional) second parameter tells INDIRECT
whether to use A1-style references (if TRUE)
or R1C1-style references (if FALSE).
1 evaluates to TRUE.
I hadn't included the second parameter in my
original post because it seemed extraneous.
--tim f-w
