ranking part numbers with cost (highest to lowest)

Based on my example, I like to find a function that when I use the word Spring on F4, lines F6 to F9 will have those part numbers tied to the Spring word. By the way the table is located on columns B, C, and D. That's not the end of it.

If you look at the result, you'll see that the part numbers are listed from the highest to the lowest cost.

I was wondering if you guys can help me with this.

Thank you.