Multiple searches in one cell

[AlirezaSharyan]

Dear all.

I have a data sheet which contains three data columns: Part code, Description and Bin#

I need to make two searches within the "DESCRIPTION" column data (Shown by arrows in the image below) and find the PART No. and Bin# as the result. The problem is, both searches shall be done within cells in one column and the derived data are not unique. For example, many cells in "Description" column contains the string "LCD" and many others contains the string "N988F". And what I want to do is to find one or more cells which contains both strings and then find the corresponding cells in other columns (PART No. & Bin#)

 

[AlirezaSharyan]

And what if I want to add one more search box? For example, make three search input cells. The type inputs like... LCD, A025, Black in each cell and find the results.