Find Jobs
Hire Freelancers

Vlookup/ Match excel macro to sort data in spread sheet.

$10-30 USD

Closed
Posted over 6 years ago

$10-30 USD

Paid on delivery
PROBLEM: I have a mass of data in an excel spreadsheet that I need to correlate with another Excel spreadsheet, and export the "overlap" between the two spreadsheets to a new spreadsheet. THE DATA: The spread sheet has many columns but I only care about 4 columns. The other spreadsheet is not as large as the first and definitely manageable. MY "SOLUTION": I want a VLookup or Match script that will search the data, correlate between the two spreadsheets and export the selected result to a new spread sheet. (You can suggest a different approach if my solution is not the best.)
Project ID: 15854148

About the project

43 proposals
Remote project
Active 6 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
43 freelancers are bidding on average $25 USD for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I 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. Proposed Milestones $50 USD - Please pay me once job is 100% done.
$50 USD in 1 day
5.0 (846 reviews)
8.9
8.9
User Avatar
HI, I am good at Excel and vba. I have reviewed the project details. My suggestion is to copy the data and use conditional formatting to check it quickly the duplicates with a helper column -Chandra Relevant Skills and Experience Excel, vba, Data Analysis Proposed Milestones $30 USD - Milestone
$30 USD in 0 day
5.0 (1095 reviews)
8.3
8.3
User Avatar
Hey, I'm interested in your project. Please send me a message so that we can discuss more. Stay tuned, I'm still working on this proposal.
$20 USD in 1 day
5.0 (490 reviews)
8.0
8.0
User Avatar
Hi there, This looks feasible and I can use array or SQL queries to make it fast and efficient. I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman
$35 USD in 1 day
4.9 (179 reviews)
6.6
6.6
User Avatar
Hi I have multiple suggestion based on vlookpup ,countif,match functions in cojunction. I can complete the job within 20 minutes. I need data files. I have 10+ years of experience in Excel Relevant Skills and Experience Excel/VBA Proposed Milestones $30 USD - Complete the job Please provide the files.
$30 USD in 1 day
4.9 (181 reviews)
6.1
6.1
User Avatar
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 8 years of IT experience. I have successfully completed few projects Relevant Skills and Experience Excel(Advanced) VB Proposed Milestones $35 USD - This task will be completed within schedule
$35 USD in 1 day
4.8 (78 reviews)
6.2
6.2
User Avatar
Hi, there I can code your current Excel using sql/ado coding within - that's a just proper way here in your task Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $55 USD - default
$55 USD in 1 day
4.8 (42 reviews)
6.2
6.2
User Avatar
Hi ! Let me help you i will check which formula will helpful for getting require results. Thank you ! Relevant Skills and Experience Have 5 years of excel exp Proposed Milestones $10 USD - excel work
$10 USD in 0 day
4.8 (72 reviews)
5.8
5.8
User Avatar
Hi, I have over five years experience in using Excel at an advanced level (formulas, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to improve my work quality and productivity and I made complex Excel sheets to automate my tasks. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$20 USD in 2 days
5.0 (23 reviews)
5.7
5.7
User Avatar
Hello, I went thru the des. This can be done within today Kindly check my past job work and vllokup or match will do this Today can start. Looking forward to hearing from you Thanks Regards Thushara Relevant Skills and Experience Data Entry, Data Processing, Excel,Visual Basic Proposed Milestones $25 USD - once done
$25 USD in 0 day
5.0 (37 reviews)
5.1
5.1
User Avatar
I have good command over MS Excel especially povit table, charts, advance formulas etc, codes. do let me know more detail in PM. thanks
$30 USD in 1 day
4.9 (33 reviews)
4.4
4.4
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
4.8 (11 reviews)
4.2
4.2
User Avatar
Dear Customer . i understand your requirement and will Provide sample work within 1 hours. trust me and Hire me . Relevant Skills and Experience I have complited many data analytical work high quality and accuracy last five year. using microsoft word,microsoft excel perfectly. Proposed Milestones $12 USD - project i can start now your project according to the your guide line with Confirmation.
$12 USD in 0 day
4.9 (12 reviews)
3.7
3.7
User Avatar
25 USD for 1 day working Relevant Skills and Experience I have over 10 years of experience and knowledge of accounting and good skill data entry, good at Office software and Xero, Myob, Quickbooks software all so Proposed Milestones $15 USD - Milestones $10 USD - Payment
$25 USD in 1 day
4.6 (7 reviews)
3.8
3.8
User Avatar
Hello sir, I am a computer engineer. I am working with software development and debugging. I read the task details. Using VLookUp is definitely what you can go for but if you want to automate it, you can have a utility that does this task, benefit of such is it will be helpful when number of rows are so many and processing speed is crucial factor. I have done not this but similar task in Excel using integration of Java. I had got satisfactory result in it. So if you think this solution may be applicable, do text me for providing spreadsheet details. I will surely help in it if I can. Thank you.
$30 USD in 3 days
4.3 (13 reviews)
4.2
4.2
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
5.0 (4 reviews)
3.0
3.0
User Avatar
Create a Vlookup/match formula in excel Relevant Skills and Experience Hi! I have experience in excel. I've complete many automating task with excel for the company I was interning in. I am rigorous and conscientious; I'll complete the task to the highest standard. Proposed Milestones $25 USD - Create a Vlookup/match formula in excel
$25 USD in 1 day
5.0 (6 reviews)
2.7
2.7
User Avatar
its a simple program of link up, sort and compare. Would complete the project in 6 hrs of starting the project
$15 USD in 0 day
5.0 (3 reviews)
1.4
1.4
User Avatar
The solution of the problem with VLookup, Match or with other appropriate excel formula can be done. Relevant Skills and Experience excel Proposed Milestones $25 USD - day
$25 USD in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
enough exp in this sub matter
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Dec 12, 2017

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.