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;""))
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;""))
HansVogelaarThanks, that helped!
And for other readers: don't forget to presss CTRL+SHIFT+ENTER afterwards, or it won't work.