How to Lookup Multiple Values in Excel (10 Ways) - ExcelDemy We’ll compile a list of all businesses (from C) run by a specific person Steps: In an empty row, provide a list of unique names The names are entered in cells B13:B15 in this example Enter the following formula in the cell C13 Use AutoFill to see the results Here’s the result We modified the result table Steps: