I have a list of product codes and the number of characters vary. I'm trying to lookup a product from my product list to a partial part number, returning the partial part number. The first list is my product list and the second list is the partial part list. The difficulty in this is that the partial part list isn't nessarily the first few characters of the product, some are the first few characters and some are characters in the middle of the list. Does anyone know if there's away to look these up?
Partial Part #