Forum Discussion
Solved
TEXTJOIN formula to search for value with multiple results
Hello all, I'm trying to apply the TEXTJOIN formula to search for a value and get multiple results. My data looks like this: A B C D E F 1 Column1 Column2 Column3 Uni...
You separate the arguments inconsistently - a mixture of commas and semicolons.
Do you use point as decimal separator? If so:
=TEXTJOIN(",",TRUE,IF(E2=B:B,C:C,""))
But if you use comma as decimal separator:
=TEXTJOIN(",";TRUE;IF(E2=B:B;C:C;""))
If you have Microsoft 365 or Office 2021, you can also use
=TEXTJOIN(",",TRUE,FILTER(C:C,B:B=E2))
or
=TEXTJOIN(",";TRUE;FILTER(C:C;B:B=E2))
depending on your decimal separator.