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 formulas: dropdowns and vlookups
Sign in to Add to Watch List

Admin Support > Data Entry

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Tue, Sep 11, 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: $20 - $60
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need to edit 4 excel Templates that with a couple of formulas: mainly drop downs and vlookups: here are the details and the files:

1. Template 1: Hotel Template
Hotel drop-down
1.1 When user select a value from a drop down in "Hotels with
Amenities" tab, column G, it should auto populate Column F in the same
sheet, based on a table exists on "current amenities" tab.
1.2 User will manually feed Hotels and Hotel ID in the first
tab:"Hotels with Amenities", each Hotel that is entered there should
auto-populate in the second tab:"Hotel Age Ratings" (Column C and E)
1.3 in "Hotels not on Hotels Combined" tab - Column B should be a drop
down (values come from "current amenities" tab), once user select a
value, it should auto populate column A (based on the table in
"current amenities" tab.
1.4 In "Hotels not on Hotels Combined" tab - same with cities: Column
E should be a drop down. Once selected - should auto populate column
A. make sure that user can write there in case he can't ...

Sign in or Register to see more

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

 United States  |  
INVITED
My name is Sarah Conine and I am a skilled document specialist. I've tested in the Top 2% for Word 2007 and 2003 on Elance. I'm A Microsoft...
2
  |  
 4.0   |  Private   |  19 Jobs   |  2 verified credential(s)
Bid ID: 33460210  |  Submitted: Sep 11, 2012 17:47 ET 
Proposal SEALED

 United States  |  
Winner
Need an Excel-based project completed? My Excel skills are tested out in the Top 1% of all eLance users and I am equally proficient in Excel 2013,...
2
  |  
 4.8   |  Private   |  14 Jobs
Bid ID: 33459971  |  Submitted: Sep 11, 2012 17:34 ET 
Delivery
Within 3 days
$54.79

 United States  |  
INVITED
I am an expert user of Excel and VBA.
3
  |  
 4.1   |  Private   |  2 Jobs
Bid ID: 33459849  |  Submitted: Sep 11, 2012 17:28 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 »