Have you thought about using Data|Filter|Autofilter.

Then you can use the arrow in column A's header to choose
Custom|Contains
exchanger

If you need the data in another spot, you could copy and paste from there.

Severin wrote:

I am searching for partial data in column and want to return all possible
queries.

Example: Search item in cell B1
Find all items on a second sheet in column a1 that contain b1 from original
sheet.
Not looking for exact matches, in other words a1 contains "exchangers" and
on the other sheet column a1 might contain "heat exchangers" or just
"exchangers"

I want to return not only "heat exchangers" or "exchangers" but also the
info in the rest of the row.

A1 B1
1 Item Location
2 Exchanger Tank Farm 1
3 Heat Exchanger Tank Farm 2

Thanks for any help.
If not clear ask and I will try and clearify.

--

Dave Peterson