# Pricing Based On Cell Reference And Drop Down List

1. ## Pricing Based On Cell Reference And Drop Down List

Hello,
I am trying to create a formula to do the following:

By choosing the number of passengers and then choosing the "Type of Adult" from the list below, to calculate the base fee them multiplied by the amount number of Adults. Example would be below:

Gate Fees
Intl Adult R700,00 Intl Child R312,00
SADC Adult R300,00 SADC Child R205,00
SA Adult R500,00 SA Child R200,00

Type of Game Drive Number of Adults Type Of Adult Adult Gate Fees Number of Children Type of Child Child Gate Fees
Shared Morning Drive 1 Intl Adult 1
Shared Afternoon Drive
Shared Full Day Drive

Each of the "Types" would be a drop down list and then trigger the calculation. Hope this makes sense.

2. ## Re: Pricing Based On Cell Reference And Drop Down List

Answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

3. ## Re: Pricing Based On Cell Reference And Drop Down List

Hi JohnTopley,
The spreadsheet is now attached. Thanks

4. ## Re: Pricing Based On Cell Reference And Drop Down List

In D8 as example

=VLOOKUP(\$C8,\$A\$2:\$B\$4,2)*B8

See attached

The current format does not allow for a "mixture" of types (adult or children) in a single trip

5. ## Re: Pricing Based On Cell Reference And Drop Down List

John,
Cheers! This makes much more sense.
Thank you

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1