concatenation and INDIRECT

  • Thread starter Thread starter Gromit
  • Start date Start date
G

Gromit

A1: 5
A2: A
A3: 1
A4: =INDIRECT(A2 & A3)

A4 Gives the result of 5

However,

B1: 5
B2: B
B3: 1
B4: =INDIRECT(B2 & B3 & "+" & B1)

B4 Gives a REF! Error.

Can anyone please help me understand the logic of why the second
formula doesn't work? Concatenation works in the first, why not the
second?
 
Oh,

Don't worry about this. I realise it doesn't work because the second
example doesn't return a cell reference.

G
 
If you simplify your parenth. in the second formula you
get B1+5, and then you are asking Excel to use this value
as a cell reference. There are not any cells with a
reference of B1+5.

Rudy
 
If you simplify your parenth. in the second formula you
get B1+5, and then you are asking Excel to use this value
as a cell reference. There are not any cells with a
reference of B1+5.

Rudy
 
Back
Top