TEXTJOIN and Array IF Statements to Look up and Combine text in excel
http://theexcelclub.com/looking-up-an...
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