Hi All

I have an inventory spreadsheet that has an A1 column approx 5000 rows long, that has part descriptions and a B1 column of part locations Approx 5000 rows long.

I want to be able to enter a search criteria in a 3rd column say c1 and be able to look for partial matches in the description column.
For Example

if the Description says "Guide Roller shaft" I would like to be able to display the part location in the column next to it if I were to enter "Guide" or "Roller" or "Shaft" in the search criteria box

SO if the columns were as follows and I entered "Roller" or "Guide" or "Shaft" in to C1 I would see A178 in D1 my results column.
Also there may be several instances of the search criteria found within the description column. I would like to be able to see all locations returned in a list below the D1 column heading.

A1 b1 C1 D1
Guide Roller Shaft A178 Roller A178