Not quite what you're asking, but maybe you could apply Data|Filter|autofilter
to your range.

Then you could filter to show the rows you want.

Emily wrote:

I don't know if there is a function for this or how to create one, but I want
to be able to search my inventory list. I would like to be able to, type in
"Zanes" then have all things related to that word shown to me, such as: stock
#, Quanty, Reels, Spools, and so on. If I were to type in "reels" then I
would like to be able to see all the reels, that are in my inventory. I hope
this makes sence.

Thank you
Emily

--

Dave Peterson