TEXTJOIN only when the condition is true.

Hi friends

I am novice in Excel Still Learning, I can't figure correct formula for the joining text if condition is true.

Hope someone can look and fix my formula and any other option to get result will be better.

Thanks

Please Login or Register  to view this content.

If sheet2 product code found in sheet1, match all product and join them into one column.

You're almost there, it should be

Formula:

Please Login or Register  to view this content.

thanks for your time and reply Fluff13

I know it must be my fault But Following Code not working in sample sheet.
I also know it should work. But something missing i Don't know what..

Please Login or Register  to view this content.

Did you add the {} brackets manually? If so don't, remove them & whilst in the formula bar press Ctrl Shift Enter

Did you add the {} brackets manually? If so don't, remove them & whilst in the formula bar press Ctrl Shift Enter

Thanks once again !!

sorry for replying late, i want to make sure before reply if i'm still missing something or not.
But Result is same .... result not coming ...

!Please Don't make extra effort on it. check it we whenever you free.

Thanks

Please Login or Register  to view this content.

Attachment 785902

With xl 2019 you need to confirm the formula with Ctrl Shift Enter, rather than just Enter.