Looking up and Combining text using TEXTJOIN and Array IF Statements.
Looking at the table of data below, how would you go about looking up the order number and pulling the name of all products sold on that order into the one cell as shown in cell B19 in the image below? Looks complex right? But not really with the use of TEXTJOIN and Array IF […]