Hi, I have a problem to solve which is explained in the following 3 steps:
1. One column is there in which there are over 20,000 text strings which contain random data. Strings can be like: "$300 and above Weather Stations" OR like "Kestrel 5500 Weather Meter - IC-0855".
2. Another column contains 10,000 unique product codes.Codes can be like: "0810-0004
" or "IC-0855"
3. The task is to search every string (in step 1), if there is any of the product codes present in that string, return that product code in front of that respective string. For example from the first two steps, I can see that the string "Kestrel 5500 Weather Meter - IC-0855" contains a product code (IC-0855) mentioned in the column containing product codes, so I want to return that product code in front of this string,
I am attaching the sample data file if someone can help me with this. I thought VLOOKUP could help in this, but I couldn't find out a way around it, too.
Thanks in advance.
Bookmarks