I have a range of parts that I must categorize by department. The parts are categorized by a range of keywords, example: KEYWORDS Engines clutch alternator flywheel I then have another list of parts in another range. Example: PARTS REQUIRED Part List seats doors heavy duty clutch steering wheel standard clutch I want the formula/code to return both the clutches listed in separate cells on another sheet. Really struggling with how to do this, I can get it to return a single cell using lookup or get it to return a true/false statement if there is a match of any keyword but can't seem to wrap my head around returning each cell with a match. Help appreciated.