Đã hoàn thành

Sorting and extracting data from 2 excel files

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem nhiều hơn: extracting data website excel sheet, extracting data website excel, search data several excel files, compare excel files sample, extracting data web excel, grab data multiple excel files, data filling excel files, extracting data word excel, import data closed excel files vba, extracting data racing excel post website, extracting data websites excel data mining, find data difference excel files, prestashop data entry excel files, data entry excel list sample, data entry excel files download, Transcribe data from multiple excel files to one excel , create script for creating many excel files from one big excel file

Về Bên Thuê:
( 8 nhận xét ) Norsborg, Sweden

ID dự án: #16481806

Được trao cho:

ShahzaibKha

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.

$10 USD trong 1 ngày
(2 Đánh Giá)
0.8

70 freelancer đang chào giá trung bình $24 cho công việc này

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Thêm

$50 USD trong 0 ngày
(589 Nhận xét)
8.2
Eagles90

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

$30 USD trong 1 ngày
(124 Nhận xét)
7.6
schoudhary1553

Hi there..... Warm Greetings We came along with your request for Sorting and extracting data from 2 excel files and we reviewed your project description. We'd like to help you with confidence and satisfying resul Thêm

$30 USD trong 1 ngày
(264 Nhận xét)
7.6
semi786

Hi Sir/Madam, It is being my pleasure to introduce you to me. I am expert in advance excel. I have excellent knowledge of advance excel and VBA macro coding. I know many things in excel like Formulas (Countif, Sumif Thêm

$22 USD trong 0 ngày
(256 Nhận xét)
7.5
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I will sorting and extracting data from 2 excel files. I have always created a long-term colla Thêm

$30 USD trong 1 ngày
(335 Nhận xét)
7.7
Webxpert4u

Hello, I am ready to merge data from both excel files to one master file. Final file will have all links in separate columns for a same article number. Highly experienced in Excel Programming, Excel automation and M Thêm

$34 USD trong 1 ngày
(238 Nhận xét)
7.5
shosi

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.

$25 USD trong 1 ngày
(107 Nhận xét)
7.1
pandey2008

hello sir, we can do this job and try to finish asap, thx

$25 USD trong 1 ngày
(511 Nhận xét)
7.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$30 USD trong 1 ngày
(274 Nhận xét)
7.1
saqibmunir55

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

$24 USD trong 1 ngày
(469 Nhận xét)
7.1
sergiuloghin

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!

$25 USD trong 1 ngày
(192 Nhận xét)
7.1
MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've completed many similar projects, and for this you need custom macro, that will process file B and generate file A automatically. I Thêm

$25 USD trong 0 ngày
(384 Nhận xét)
6.7
asifdwan

Hi there! I have read the project details and ready to start it right away. I am an expert in extracting data and data scraping jobs.I have huge experience in this type projects. I look forward to hearing from you Thêm

$30 USD trong 1 ngày
(211 Nhận xét)
6.9
best4best

Hi, I can do it in 1 hour with 100% accuracy. I am an Excel expert. Regards Soni

$20 USD trong 1 ngày
(189 Nhận xét)
6.5
Venkat2011sri

Hello, I am ready to do this task, Please ping a message, i will do this task right now, i look forward to work with you, Thanks.

$10 USD trong 1 ngày
(163 Nhận xét)
6.7
onlinejob247

Hi there, I am ready to start right now ! I have check the project details and lots of experience extracting and different types of projects. I’m waiting for your quick positive reply. Feel free ask me question Thêm

$25 USD trong 1 ngày
(78 Nhận xét)
6.1
$25 USD trong 1 ngày
(54 Nhận xét)
6.1
mariusalex86

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.

$18 USD trong 0 ngày
(66 Nhận xét)
5.6
sajibdigital

Hi, It is simple Project for me. If you give me a chance to do it, I can finish it in 10 mins. Thanks

$15 USD trong 1 ngày
(67 Nhận xét)
5.7
archanaoswal

I have excellent command on MS Excel. This can be achieved using array formulas along with lookup and I can complete it within a day. I have completed complex projects in Excel before . For instance - Get match deta Thêm

$30 USD trong 1 ngày
(45 Nhận xét)
5.2