Sorting and extracting data from 2 excel files

$10-30 USD

Opravljeno

Objavljeno

pred približno 6 leti

$10-30 USD

Plačilo ob dostavi

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.

Data Entry

Data Processing

Excel

ID projekta: 16481806

Več o projektu

64 ponudb

Projekt na daljavo

Aktivno pred 6 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@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 v 1 dnevu

5,0

(2 ocen)

0,8

64 freelancerjev je oddalo ponudbo s povprečno vrednostjo $24 USD za to delo

@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 Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Thanks, Jay

$50 USD v 0 dnevu

5,0

(835 ocen)

9,0

@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 results... We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Data Entry, Data Processing, Excel We have worked on 300+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !

$30 USD v 1 dnevu

4,9

(465 ocen)

8,4

@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 v 1 dnevu

5,0

(218 ocen)

8,4

@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, Index match, Vlookup and offset etc.), Pivot, validation, macro, Pivot chats etc. Please review my profile. My profile is suitable for this project. I will complete this project on time. Please give me chance to work for you and provide me this opportunity. It will be glad for me. Thank You, Semi786

$22 USD v 0 dnevu

5,0

(573 ocen)

8,5

@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 v 1 dnevu

4,9

(400 ocen)

8,2

@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 v 1 dnevu

5,0

(488 ocen)

8,0

@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 collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$30 USD v 1 dnevu

4,9

(434 ocen)

8,1

@pandey2008

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

$25 USD v 1 dnevu

4,9

(655 ocen)

7,8

@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 v 1 dnevu

5,0

(246 ocen)

7,8

@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. If you are interested in working with me, feel free to message me and i will try to help immediately. Thanks, Milan

$25 USD v 0 dnevu

5,0

(654 ocen)

7,3

@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 v 1 dnevu

5,0

(212 ocen)

7,4

@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 v 1 dnevu

4,9

(747 ocen)

7,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. Regards

$30 USD v 1 dnevu

4,8

(284 ocen)

7,4

@aubrey03

A proposal has not yet been provided

$30 USD v 1 dnevu

4,9

(221 ocen)

7,0

@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 if any. I Look forward to hearing from you. Have a nice day and stay fine:-) Best Regards

$25 USD v 1 dnevu

4,9

(147 ocen)

6,8

@RPaul73

Greetings, Have gone through and understood the requirements. Can turn this around in a few hours. Experienced freelancer with proficiency in Excel. Q: Would you need the formulae in the final output or just the data values? Regards.

$15 USD v 1 dnevu

5,0

(37 ocen)

6,8

@best4best

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

$20 USD v 1 dnevu

5,0

(211 ocen)

6,7

@c4cuteconain

I am a professional accountant with years of experience working with excel and office. can help you with any excel related problem.

$20 USD v 1 dnevu

4,9

(124 ocen)

6,3

@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 v 1 dnevu

5,0

(90 ocen)

5,9

@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 v 0 dnevu