vlookup partial match multiple return

Hi all,

I have a spread sheet of about 30k part skus, and their descriptions. I'm trying to create a function that will vlookup based on multiple words, seeking partial matches, and returning multiple results. I need to type in something like "3/8 nut", but return results such as "3/8" zinc hex nut" and "3/8" galvanized hex nut". I'm finding the problem is that there are other words in between "3/8" and "nut" from the original search. I attached the spread sheet i'm talking about. I deleted most skus for the save of file size. I will copy and paste the rest back in based on everyone's help.

Please!

I've been working on this for months and can't make it work. This would GREATLY improve my day to day operations at work.

I can definitely make this work. Thank you!!