Range Contains Specific Text Based on Inputs – Index the Match

I have a range of data, say, B2:C100, where Column B is a list of part numbers and Column C is the corresponding description of that part number. Based on a number of given inputs (keywords to search within the descriptions), I would like for the cell containing the formula to give me the first part number (corresponding row cell in column B) associated with the description that matches/contains all of the inputs. Note that the descriptions each are a string of text and it only needs to see if the keywords are found anywhere in the description.

A more complicated version might be able to tell me if there are multiple ones and what all of the matches are. 

 

Thanks!

By: Austin

Leave a Reply

Your email address will not be published. Required fields are marked *