Forum Discussion
GJG_MS
Sep 22, 2022Copper Contributor
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...
sivakumarrj
Sep 23, 2022Brass Contributor
Just try with giving specific data range
=TEXTJOIN(", ",TRUE,IF($A6&B$4=Sheet3!$A1:$A200,Sheet3!$C1:$C200,""))
=TEXTJOIN(", ",TRUE,IF($A6&B$4=Sheet3!$A1:$A200,Sheet3!$C1:$C200,""))
- GJG_MSSep 23, 2022Copper ContributorI tried that. It doesn't work.