TEXTJOIN and Array IF Statements to Look up and Combine text in excel

To take part in discussions on this video please visit the post above.

In this video you will learn how to combine text from multiple cells based on a criteria that you need to lookup. To do this we will be using a combination of TEXTJOIN and Array IF statements

You can get a copy of the data used to practice along on the blog

[haydiab]

This is gold. Now I can create a button for sending WhatsApp orders without one by one typing/copy-pasting them thanks

[khalidmajeed]

great great great you solve my problem. I love it

[zachb]

You've saved me from a lot of work, thanks!

[roopinig]

This saved me a lot of time.great video.thank you very much

[viennaman]

Thankyou for the help today! Nice video. Easy to understand.

[payattention]

this will be very helpful when writing thank you

[balajimurugadoss]

Hi, what if you have duplicates in the return value. like cables twice but don't want repeated values

[amitghale]

Could you please let me know the reason I am getting the end result as " #VALUE! ".. This really got me scratching my head as I tried multiple of times trying to figure out the issue.. I have also checked the formula evaluation and everything seems perfect except the end Thank You Paula! :)

[himanshudalai]

can you also share the excel sheet for practice purpose. This would be really helpful. Thanks.

[daae_rion]

Hi! Thank you so much for this video. What if you don't want it to return repeat values? So if for some reason cable was listed twice on the order, but you only wanted to see "cable" listed one time in the new cell.

[fitriyunita]

hi mam.. thank you fior the video... this formula is what i need.. but, why it doesn't work in my excel ?
Could you help me mam? why it's doesn't work?