Indirect to combine three cells' values

[errtu]

trying to combine three cells with indirect.

One of them has Text (a19), the other two have numbers (b2) and (a20)

 

[VoG]

Like this?

Excel Workbook
	A	B	C	D
1			A19	Fred320
2		3	B2
3			A20
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19	Fred
20	20
Sheet9

 

[errtu]

yes like that, I get #REF

 

[VoG]

What is the formula that fails?

 

[errtu]

What is the formula that fails?

ok I put all the data into a column like you suggested. So:

b2's value goes to a21 with

=indirect("b2")

a19 and a20 are already there so nothing.

then

=concatenate(indirect(a19),indirect(a20),indirect(a21))

 

[VoG]

Unclear. Which cells are addressed indirectly and which directly?

P.S. You should be able to figure this out for yourself.

 

[Aladin Akyurek]

trying to combine three cells with indirect.

One of them has Text (a19), the other two have numbers (b2) and (a20)

What do you have in A19, A20, and B2 exactly and what is the outcome you want to obtain?

 

[errtu]

What do you have in A19, A20, and B2 exactly and what is the outcome you want to obtain?

A--------------------B-------------------------C
--------------------12648------------------------
LGR-----------------------------------------------
1--------------------------------------------------
--------------------------------------------------
LGR126481--------------------------------------


I have those 3 cells. I want to combine them to get LGR126481.

 

[Rick Rothstein]

A--------------------B-------------------------C
--------------------12648------------------------
LGR-----------------------------------------------
1--------------------------------------------------
--------------------------------------------------
LGR126481--------------------------------------


I have those 3 cells. I want to combine them to get LGR126481.

I'm confused... why are you talking about the INDIRECT function when the cells you want to reference contain the values you want to work with. Doesn't this do what you want (or am I missing something)?

=A19&B2&A20

 

[errtu]

I want to use indirect cause the values in those cells changes constantly. I've used direct referencing with changing cell's values and I've had problems. I've fixed them using indirect. That's why I wanted to use it here.

I'll use =A19&B2&A20 like you suggest and hope for the best

thank you and sorry for not being clear