Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Need to cross reference two spreadsheets and pull out email addresses/info
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.


Job awarded.

Jun 5, 2012

Job Description

  |  Change History >>


  • Posted: Sun, Jun 03, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

We have two excel spreadsheets. One has a small amount of data and one has a large amount of data. We need to parse the one with the large amount of data and extract an email address and phone number when certain parameters are matching on the two spreadsheets adding that extracted info into the spreadsheet with the smaller amount of data. Preferably need a tool or script that can do this on a regular basis as there may be more files that the same thing needs to be done in the future.
Added 3 JUN 2012, 13:45 PM EDT
Attached are two sample files that we will need to be using.
We need to start with 2010 IRS ERO Data (09 Tax Yr)-Master.xls and take the name in the contact column and then pull the email address(s) and phone number(s) from the file NY-PTIN-my-areas-actual.xls that have that contact name associated with it.

Please note, the file NY-PTIN-my-areas-actual.xls has data in different columns and is not perfected so your parse cannot b...

Sign in or Register to see more

Job ID: 30970812
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

More than 8 years of Software Development Experience in PHP, JavaScript, MySQL and Web 2.0 technologies. Specialization lies in CakePHP, Yii, Zend,...
 0.0   |  Private   |  3 Jobs
Bid ID: 31010545  |  Submitted: Jun 5, 2012 04:45 ET 
Proposal SEALED

Ilija P.      
Ilija P.'s identity has been verified.  Learn More
 Serbia  |  
My job is to make magic happen. In short solve problem.
 4.8   |  Private   |  4 Jobs   |  1 verified credential(s)
Bid ID: 30997569  |  Submitted: Jun 4, 2012 15:52 ET 
Within 1 day

Vicente G.      
Vicente G.'s identity has been verified.  Learn More
 Philippines  |  
I gather and transform information - the largest commodity now being traded in the world. Show me the source of the information that you need, and...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30980510  |  Submitted: Jun 4, 2012 02:57 ET 
Proposal SEALED

 Egypt  |  
I am fully qualified to do the following: 1- Excel, Word and outlook scrips and programs(VBA macros). 2- New excel Functions creation. 3-...
 5.0   |  Private   |  1 Jobs
Bid ID: 30971814  |  Submitted: Jun 3, 2012 14:46 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »