Hello everyone. I am new and came here looking for help on a problem I am having.
I am looking for some sort of formula that will allow me to search a large spreadsheet for partial matches. I will be honest that I don't always understand how the formula works, so please be patient if I do not follow.
I have a large spreadsheet that has my companies part numbers in column A. In the other columns I have different information such as description of part, vendors, those vendors part numbers, and part number cross references. I have information all the way out to column AD, and rows all the way down to 6300. From time to time we get new vendors that supply us with parts listings for what they carry.
So I am looking for an easier way to cross reference our spreadsheet to see if we have our company's part number already set up for that part number or a cross reference. I can't do an exact match lookup because they may have added letters or numbers to the part, or they may have the part number all grouped together as one number and our spreadsheet has them with spaces or dashes.
I realize that I may get some false matches since I would only be matching partial information, but even that would still allow me to narrow it down. Right now I am stuck switching back and forth between worksheets and just using the Find icon (Cntrl + F). But I would like to find a formula that will allow me to lookup the information from a cell on one worksheet, and if it finds it anywhere in the other worksheet it would return our part number from Cell A. Then I would be able to go through them and compare descriptions to see if they are truly the same part. My plan was to break down the part numbers from the new vendors sheet into separate cells. That way I could eliminate the added letters, dashes, or manufacturer down to individual columns.
Is there something that will allow me to do this, or am I stuck using the Find function and going one by one?
Any help would be appreciated.
Thanks
Shawn
Bookmarks