I have a listing of good product numbers in Sheet 1 column A. I have
partial numbers and in some cases the complete product number in column
1 Sheet 2. I want to be able to retrieve, ie. find the match in column 1
sheet 1 given the fact that my product numbers may not be complete in my
second list Sheet 2 Column 1.


To explain the problem more clearly. I have a list of tool rental
equipment with their product ID's. They are of varying length. Some have
dashes slashes etc(eg. 28/2). I have the equipment which is used out in
the field and the product numbers in some cases have been worn off. I
might be missing the beginning end or middle of a number. I want to be
able to quickly match the partial number with my master list in Sheet 1.

Any help would be greatly appreciated as to how I might match up(best
efforts) Sheet2 Col 1 with Sheet 1(Master) Col. 1. There are literally
thousands of items and I'm going nuts trying to find the equipment in
the master List(Sheet 1)

Help

Regards

Ronald Cayne