Arie Bos
Board Regular
- Joined
- Mar 25, 2016
- Messages
- 224
- Office Version
- 365
- Platform
- Windows
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:
,
but that formula gives a general error, excel does not regard it as s formula("there is a problem with this formula")
Excel Formula:
=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")