gtin data excel for wigs

There are two pages. Page 1 is a download from OUR SITE on simple products from a VENDOR who supplies WIGS in MANY COLORS to us. Each color has a GTIN number. Our data was manually added and is not pristine. There are missing GTINs, wrong GTINs, missing COLORS (they make a color but we dont show it ) and extra colors ( we show a color they stopped making ) . The NAMES of the wigs match closely - but not precisely to the names of the wigs in the vendor's file. If you ask me to, I think I can make them match with excel. My skills are good enough to FIND and replace numbers - which are inlcuded in the name in the vendor file - with blanks - and that would do it. Find 1 replace with blank, etc. | 5 if you can get the GTIN numbers in column E on page 2 ( vendor file ) inputted into the right products on page 1 ( Magento File ) - it is done. If there are colors we are missing and you can identify them - better. If there are extra colors we show that they no longer make - good as well. There are about 8 Vendors of wigs we deal with -- But i sent this one first --- concatentation is not my forte -- if you do this and teach me how to do the rest -- that would work as well -- feel free to email me or text 818 423 1533 - i would say call., but if i dont rwecognize a number i often dont pick them up -- once i know you - i save you - and then its easier -- joseph aronesty. [login to view URL]