With 1.7 million freelancers, we'll match you with the perfect talent.
The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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
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