176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Excel lookup formula
Sign in to Add to Watch List

IT & Programming > Data Analysis

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Nov 8, 2013

Job description changed. New Version|Previous Version

Nov 8, 2013
Close

Job Description

  |  Change History >>

Updated

I need an Excel LOOKUP formula written that will allow me to look up a number that has leading zeros. Example "00182" and use that as a reference field to look into another Excel sheet to see if the corresponding number is also in that sheet and return a value if TRUE.

I need an Excel LOOKUP formula written that will allow me to look up a number that has leading zeros. Example "00182" and use that as a reference field to look into another Excel sheet to see if the corresponding number is also in that sheet and return a value if TRUE. This could also be done with a macro.

Nov 8, 2013

Close
  • Posted: Fri, Nov 08, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    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

I need an Excel LOOKUP formula written that will allow me to look up a number that has leading zeros. Example "00182" and use that as a reference field to look into another Excel sheet to see if the corresponding number is also in that sheet and return a value if TRUE. This could also be done with a macro.

Sign in or Register to see more

Desired Skills
Microsoft Excel
Job ID: 49048948
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Bombea C.      
Bombea C.'s identity has been verified.  Learn More
 Romania  |  
I have advanced skills in complex excel formulas, VBA, importing / exporting data to / from excel. I am a business consultant, i know the...
10
  |  
 5.0   |  Private   |  20 Jobs
Bid ID: 49050784  |  Submitted: Nov 8, 2013 13:06 ET 
Proposal SEALED

 India  |  
I believe in keeping my customer ("YOU") in the center for whatever I do. With more than 7 years of hands on experience in creating Excel/Access...
7
  |  
 5.0   |  Private   |  13 Jobs
Bid ID: 49050465  |  Submitted: Nov 8, 2013 12:59 ET 
Proposal SEALED

Gabriel Mendoza      
Gabriel Mendoza's identity has been verified.  Learn More
 Nicaragua
I am experienced MS excel with VBA developer. I also work doing systems in Visual Basic 6, Visual .net, MS access, SQL , C++ and Matlab GUI.
6
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 49050289  |  Submitted: Nov 8, 2013 12:55 ET 
Proposal SEALED

Thilaka Arul      
Thilaka Arul's identity has been verified.  Learn More
 India  |  
Winner
I have dealt with very complex excel spreadsheets having a mix of Formulas, Macros and Charts. Pretty good at designing eye catching Excel...
5
  |  
 5.0   |  $1,455 Earnings   |  4 Jobs
Bid ID: 49049951  |  Submitted: Nov 8, 2013 12:47 ET 
Delivery
Within 1 day
$32.88
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »