I have 2 excel files.
File 1 contains A column with article numbers. Column B,C,D,E... are image url. (these are empty).
File 2 contains 2 columns. Column A contain article numbers and column B contains image urls.
But there are several rows with same article numbers but different urls.
I want to import urls from File 2 to File 1, but I want the URLs to be pasted in Column B, C, D and so on. I think I need a Vlookup formula but in this case it has to search for the same article number, but paste the result in different columns as there are more than 1 of same article numbers.
Please find attached sample files.
Được trao cho:
Hi There, I have already worked on the sample files provided, its ready to be shared immediately, so soon as i am assigned the project I'll share the sample files for your review.
70 freelancer đang chào giá trung bình $24 cho công việc này
Dear Client Ready to do that for you. I am experienced in formulae and vba, so will wait for your response to proceed and do that for you. Warm Regards z
Hey :) Looking for instant delivery? I will not more than 12 minutes to complete your project "Sorting and extracting data from 2 excel files". Let's start and complete now. Thank You, Faisal A.
sure i can sort and extract data from excel files sure i can sort and extract data from excel files sure i can sort and extract data from excel files
Hello! I checked the 2 excel files. I can help you sort and extract the data now. I am available and I can finish in a couple of hours. You will not be dissapointed, I have a big 36% rehire rate. Thank you!
Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, focused on quality and accuracy. Kindly consider my proposal. Thank you.