I am working on a project where I need to upload products to my website. To accomplish this, I need a .CVS file with specific information in each row and column. The manufacturer has supplied the information, but it is not in the same format needed for a successful upload. There are over 80,000 rows of data that need to be completed using an automated process and I do not know how to do it and need help with a formula to automatically fill the cells with the correct data. I am not an excel expert so I do no know if this can be done, but here is what I need.
I have several filled columns with data in them and that data needs to be used to fill two blank columns using an automated process.
The ImageName in Column H needs to autofill into the appropriate cells in Column F & G as shown in the attached example.
As you can see in the example, F2-F26 is filled in red using the data from H2 Image Name because the image name in H1 matched the VendorProductCode in B2-B26.
Example H1 [login to view URL] matches B1-B26 029HBM so it is used to fill the cells F2-F26.
Also, you can see that ViewSrc1 G2-G7 is filled in green using the data from H3 Image Name because the image name matches the VendorProductCode+ColorName in C2-C7.
Example H2 [login to view URL] matches C2-C7 [login to view URL] so it is used to fill the cells G2-G7.
See attached example
20 freelancers are bidding on average $114 for this job
Hello, In my opinion i am the best candidate for your job because in my real life i am working as a data entry of Microsoft office so let our job done quickly with the cheapest price
I will provide an automated spreadsheet capable of handling future updates. This is my usual job at the university I work at, I truly hope you give me this opportunity.