Greetings,

I am certain this has been asked and answered many times but I am having difficulty finding an example that matches my needs. I have a worksheet that lists about 2,000 inventory items. one example of the contents of a column might be: "Dual Trip Coil Assy, ABB, 578B05201" and I may be searching for the word "coil". I would like to return the contents of an adjacent column (which has the catalog number), or even just the row number. As the catalog numbers are listed, sequentially, from smallest to largest, I can easily find that. I would also like to be able to easily change the word string that I am searching for to return a new answer(s). The way it is now, I have to visually scan for a word from thousands of entries.

My guess is that someone has posted this information and my hope is that someone will be kind enough to direct me to that particular post. I apologize for redundancy, but I searched as best as I could without finding the results I was seeking.

Respectfully - Baran