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.


Job awarded.

Dec 16, 2012

Job Description

  |  Change History >>


  • Posted: Sat, Dec 15, 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: $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
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Vietnam  |  
HTML5/CSS/JQuery/DurandalJS/KnockoutJS/ASP.NET High quality and on time delivery
 0.0   |  $1,508 Earnings   |  0 Jobs
Bid ID: 36071588  |  Submitted: Dec 15, 2012 23:34 ET 
Within 1 day

Pradip N.      
Pradip N.'s identity has been verified.  Learn More
 India  |  
EXCEL, WORDPRESS, IBM DataPower, WTX, JavaScript, XML, XSLT, Data Extraction, Admin Work, SQL.
 4.9   |  Private   |  18 Jobs
Bid ID: 36071492  |  Submitted: Dec 15, 2012 23:26 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choise of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »