Forum Discussion
identical TEXTJOIN formula works in one workbook but not another
Hello Excel gurus. I have a spreadsheet in which I am listing multiple matching values based on a another match, and combining those matching values using TEXTJOIN. The spreadsheet was set u...
If you look at where the #REF occurs in the formula, it should give you a better idea of what is broken (#REF usually occurs when something the formula is referring to, like a range or worksheet is completely deleted).
In the workbook that does not function, was the worksheet the formula refers to deleted and replaced with a new version/copy?
In the workbook that does not function, was the worksheet the formula refers to deleted and replaced with a new version/copy?
- No, the worksheet has existed in the same form throughout. It is a separate worksheet within the same workbook. The range still exists. I have tried clearing the cell and retyping the formula manually, but it doesn't change the result.
