See attached spreadsheet. It is MAC ExcelSample-Equipment-Hunt.xlsx
In the Jobs ws in Column A are a list of jobs. In the List ws is a named range called EQUIP.
In Job ws, column B, is a formula that checks each cell against EQUIP and returns the number of occurrences from the list that are in the cell.
Job ws, column C shows the results I want; Display the actual text (could be more than one) that is in the cell and matches EQUIP.
Solution can be a MAC-compatible Excel formula or a VB macro.
Thanks for your help!