I'm a Excel novice so I will cut to the chase. I have gotten close to what I am looking for pulling information off of other threads but have failed multiple times so I figured I would ask my specific question. Thanks in advance for any and all help.

Here is what I have:
I have a 8,000 plus dynamic inventory that gets updated periodically on my sheet #1. On sheet #2 I have a formatted sheet that I have set up to "auto fill" so when I enter a part number. My description, unit if measure, and pricing are imported from sheet #1.
I would like to take sheet #2 to the next level and create a "search" box in a cell. Basically something I can enter 1-3 description keywords into the cell, or cells if need be, that will return an array of all the product descriptions with those keywords in the description line along with the corresponding part number,i n the cell next to it. I would like an array and not a highlighted list as my inventory is fairly large and the "find" methodis what I currently use. I have a lot of hardware in my inventory so the 2-3 tier search is almost a must. For example I might have (50) 3/8 bolts of different lengths. I would like to enter the keywords"3/8" "1-1/2" and maybe"bolt" in any order get a narrowed down list of all descriptions with those entry matches in them.

Details:

Sheet #1 is inventory -
Column A = Inventory Part # (part number does contain letters)
Column B is the description text

Sheet #2 is where search cell is to be located

Would like search entry to be in cell "Q3"

If multiple cells are needed "R3" and "S3" could also be utilized as search boxes

I would like my array to start with the part number in "P5" and Description in "Q5" and continue down those columns.

Also as I mentioned before my inventory on sheet #1 is constantly being added to and updated so I would like my search cells to perform a search on the entire column in hopes that when I drop in an updated inventory I will not have to revise my search box/boxes.

Again thanks so much for anyone that is willing to help me with this. It would greatly help my efficiency invoicing and assembling purchase orders.