Download Excel File: https://ift.tt/2snUDyL
Entire page with all Excel Files for All Videos: https://ift.tt/1kSFWvs
In this video learn how to lookup a supplier name in a lookup table and return all the products in a single cell. This is a Text Formula that is also an Array Formula. This formula uses the IF Function and the TEXTJOIN Function.
List all Products in Single Cell. TEXTJOIN Function, Array Formula. Text Formula.