Hello! Is there a way to use a vlookup in cell B1 that checks if one of the vendor names from the list A11:A16 exists within the text in cell A1, then if so, uses that as the look-up value to return the corresponding vendor category in cells B11:B16 ? Hope that made sense. Thank you!