176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Spreadsheet Formula 2
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Dec 16, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Sat, Dec 15, 2012
  • 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: $50 or less
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

So now can you create the formula so it searches 2 data ranges instead of 1.
So basically if there is no match in the first data range then it searches the second.
See example:

  [obscured]  /spreadsheet/ccc?key=0AglEY-68bSCJdFdGOF9pcUVLOGJHNjZBMGJQcDlTQVE

Let me know if you would like this job. Thanks

Sign in or Register to see more

Desired Skills
Google Spreadsheets
Job ID: 36071092
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Vietnam  |  
Winner
HTML5/CSS/JQuery/DurandalJS/KnockoutJS/ASP.NET High quality and on time delivery
3
  |  
 5.0   |  $8,027 Earnings   |  8 Jobs
Bid ID: 36071588  |  Submitted: Dec 15, 2012 23:34 ET 
Delivery
Within 1 day
$25.00

Pradip N.      
Pradip N.'s identity has been verified.  Learn More
 India  |  
EXCEL, Data Extraction, SQL, Data Entry, ETL, Admin Work, Virtual Assistance, Database Handling, HTML, Photoshop
3
  |  
 4.6   |  Private   |  55 Jobs
Bid ID: 36071492  |  Submitted: Dec 15, 2012 23:26 ET 
Proposal SEALED
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 »