LOOKUPS

justin monteforte

In cell E$2,$ enter a formula using TEXTJOIN to combine the text from cells B$2$:D$2$ into a single text string. Use the # character as the delimiter. Ignore blank cells. Use a cell range as the Text $1$ argument.