Find Jobs
Hire Freelancers

Merge two Excel Tables

$10-30 CAD

Completed
Posted over 5 years ago

$10-30 CAD

Paid on delivery
I have two lists that need to be merged together so I can compare the data in them. The common reference field is the part number. I've been trying to merge using Vlookup and having problems since this is new to me. Hoping for a quick solution and then maybe I have some more data to manipulate
Project ID: 18230058

About the project

19 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
I am proficient with Microsoft excel and macro/VBA development, I can definitely help you to merge the data as depicted in your description,. Would be great if you can provide a sample of your current excel sheet. If you are interested feel free to message me, I am available to start your project immediately and deliver today. Looking forward to chat further and work on your project.
$30 CAD in 1 day
5.0 (104 reviews)
6.2
6.2
19 freelancers are bidding on average $22 CAD for this job
User Avatar
Hello Dear, I am an expert in Data Entry, Excel and I am really interested in your project. I am available to start working on it now. I work efficiently and will finish in a timely manner and will provide high quality work. I have great researching skills and would gladly work on your project. I am waiting to your quick positive reply and if you have any questions, feel free to ask me.
$30 CAD in 1 day
5.0 (271 reviews)
7.3
7.3
User Avatar
Dear Sir, I have more than 3 years experience in data entry & data processing jobs. i can merge your 2 excel file very easily . can you come in chat for interview & allow me to do your work. Thanking You Razia
$25 CAD in 1 day
4.9 (121 reviews)
5.9
5.9
User Avatar
Hello, I am Excel and VBA expert. I can do this project today. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
$25 CAD in 0 day
5.0 (94 reviews)
6.0
6.0
User Avatar
I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and knowledge.
$20 CAD in 1 day
4.9 (79 reviews)
5.8
5.8
User Avatar
"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$30 CAD in 1 day
5.0 (20 reviews)
4.7
4.7
User Avatar
Hello, i can write small vba code to merge your excel tables so you can compare can start now waiting your answer Thank you
$30 CAD in 1 day
4.9 (56 reviews)
4.5
4.5
User Avatar
Hello, I am an R programmer, I read the description of your project and here is how I will aproach your problem. I will load the data in R and merge it there, then re write in Excel ( automatically ). If everything is straight forward it should take less than one or two hours. The advantage in using this method, is that no matter how huge the file is, it will only take few lines of code to do it. I estimate I will deliver in the next 4 hours. Please share further information about the project. Thank you,
$30 CAD in 2 days
5.0 (6 reviews)
4.3
4.3
User Avatar
There are several ways: Vlookup could be ok, but if it is complex, Index & Match can beused. I can merge your tables within one hour. Contact me in the chat if you are interested. Relevant Skills and Experience Excel, data merging, formulas, match, vlookup, hlookup, index & match
$15 CAD in 1 day
5.0 (4 reviews)
2.6
2.6
User Avatar
Hi, - Chat me to discuss your project and send me more details and send Excel files to begin work, then i will correct my BID if it is necessary. - I have 9 years of experience in electrical panels field: Technician and electrical drafting & MS office work. - I have good experience with Excel PivotTable, Macro, & VBA. Don't forget to have a look on my portfolio. Best regards, Thanks.
$25 CAD in 1 day
5.0 (1 review)
0.4
0.4
User Avatar
"Hello, After reading your project description I realise that you need a professional Scraper. Yes, I am a professional Web scrapper and Data miner. My service will help about all kind of scraping project. I will gather all the data in a sheet and will provide you. It will be perfectly organized and you will be very satisfy by this. I am waiting to be hired and start working right away. Thank You."
$30 CAD in 1 day
5.0 (2 reviews)
0.0
0.0
User Avatar
Hey, I can help you with this task. Have a look at my portfolio of Design work. Let me know, if you are interested. Regards.......
$10 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I know your problem and I know it s annoying :) I really love to solve these problems. I can help you quickly. And after I find the solution, I can teach you.
$20 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey, how are you? i am new on freelancer can i get this job? You will probably like my work. Thanks! :)
$10 CAD in 0 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am very good with Excel tabels.
$20 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Will create Vlookup and other formula b/w two sheet so that you can easily compare the sheet in terms of numeric or character value
$15 CAD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Please try this " =vlookup(A2,D2:E5,2,0) After pasting formula, Delete A2, and select your common value, next, Delete D2:E5, and select the table in which your data is. Make sure to select from the common value column. Hit enter. If problem not resolved, please share the excel file with me so that I can have a look and help you out.
$15 CAD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of CANADA
SASKATOON, Canada
5.0
1
Payment method verified
Member since Nov 25, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.