Lookup keyword(s) from a range in excel and return all matches in another range

Discussion in 'Programming & Software Development' started by LayZ, Aug 14, 2018.

Tags:
  1. LayZ

    LayZ Member

    Joined:
    Sep 7, 2011
    Messages:
    97
    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.
     
    Last edited: Aug 14, 2018
  2. waltermitty

    waltermitty Member

    Joined:
    Feb 19, 2016
    Messages:
    697
    Location:
    BRISBANE
  3. OP
    OP
    LayZ

    LayZ Member

    Joined:
    Sep 7, 2011
    Messages:
    97
    EDIT: Figured it out

    Used a defined dynamic range using offset, checked each part per department's keywords then filtered if true
     
    Last edited: Aug 14, 2018

Share This Page