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)

 

[Rick Rothstein]

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

I'm still not clear why you think changing a value in a cell would be affect a direct cell reference differently than an indirect cell reference. Indirect is used to specify a cell range in text format so the addresses do not change as cells are copied or rows inserted/deleted. Based on what I have read so far, none of that protection seems to be needed by you so I really do not see where using the Volatile and slow INDIRECT function would be of any benefit to you.

 

[errtu]

You're right. I won't use it. There is no need for it here