# 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
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.

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

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