theexcelclub.com
Looking up and Combining text using TEXTJOIN and Array IF Statements. - The Excel Club
In this article and video you will learn how to lookup and combine text using Excels TEXTJOIN and Array IF Statement (contains paractice activity)