Grow table automatically

[Arie Bos]

I have Table1 with several columns, and in Table2 there is only 1 column in which I want to concatenate the strings from the first two columns from Table1 with formula: '=A1&" - "&B1'. If I add a row to Table1, Table2 does not expand for that new row. So I tried:

=IFERROR(INDEX(Table1[Column1];ROWS(Table2[#Headers])-1);"")&" - "&IFERROR(INDEX(Table1[Column2];ROWS(Table2[#Headers])-1);"")

,
but that formula gives a general error, excel does not regard it as s formula("there is a problem with this formula")

 

[Fluff]

The 2nd table will not expand if Table1 is extended. Why not just use a Spill formula in a normal range & it will expand quite happily.

 

[Arie Bos]

Hello Again Fluff!,

thank you, but I don't know how I should use that function.

 

[Fluff]

How about

=Table1[Column1]&" - "&Table1[Column2]

 

[Arie Bos]

Yes that works, silly of me, . THanks again.... up to new topic...

 

[Fluff]

You're welcome & thanks for the feedback.