I have 2 Excel spreadsheets and need to try to find matches based on product name but one file has something like Tylenol for example (only the product name) but the other file has Tylenol 100mg 100s. I want to see if the product name from my first file (just Tylenol) is on my 2nd file for the name Tylenol but ignore the 100mg 100s for example.
Is there a vlookup using a wilcard for my 2nd file or some other kind of match function? If someone could list out some code functions that would be greatly appreciated.
Thanks
Didn't try anything as I'm not versed on matching when one field name has less than the other.