Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel - assistance with mergetool or vlookup
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.

Jan 19, 2012

Job Description

  |  Change History >>


Invite-Only Job
  • Posted: Wed, Jan 18, 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
  • W9 Not Required
Sign in to view client's details

Hi Ganesh

This is Karen from LCubed, you helped us a little while back with the mergetool and also more recently on another project with Pauline.

I am wondering if you can help me. I am performing some data manipulation involving very large files, the mergetool is not able to handle it (I think there are just too many records). So instead I am using vlookup for doing the lookup function but I am having a problem with it not working correctly.

I believe the problem is due to the key I am using which is called MEMID and it looks like a number but contains letters and is case sensitive. I thought VLOOKUP would work for this but it is not.

I provide more details in the attached document.

My objective is to either have a mergetool or a formula that will allow me to successfully merge on this key.

Is this something you can help me with. Ideally I would like to resolve it this week.

Thanks for your assistance.


Sign in or Register to see more

Desired Skills
HTML, VBA, Visual Basic
Job ID: 28147174
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 India  |  
. 10 years+ experience . PDF Expert, Adobe Acrobat . Livecycle Designer . PDF forms and Microsoft Word documents / forms specialist, Microsoft...
 5.0   |  Private   |  1 Jobs   |  2 verified credential(s)
Bid ID: 28157883  |  Submitted: Jan 18, 2012 11:45 ET 
Within 1 day
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 »