Lookup and Return Multiple Values in One Cell in Excel (Formula & VBA)

Can we look-up and return multiple values in one cell in Excel (separated by comma or space)? I have been asked this question multiple times by many of my colleagues and readers. Excel has some amazing lookup formulas, such as VLOOKUP, INDEX/MATCH (and now XLOOKUP), but none of these offer a way to return multiple … Continue reading Lookup and Return Multiple Values in One Cell in Excel (Formula & VBA)