+ Reply to Thread
Results 1 to 5 of 5

Pricing Based On Cell Reference And Drop Down List

  1. #1
    Registered User
    Join Date
    03-02-2020
    Location
    Vancouver, BC
    MS-Off Ver
    Mac 2016
    Posts
    5

    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.
    Attached Files Attached Files
    Last edited by QuentinL; 04-20-2021 at 07:35 AM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    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. #3
    Registered User
    Join Date
    03-02-2020
    Location
    Vancouver, BC
    MS-Off Ver
    Mac 2016
    Posts
    5

    Re: Pricing Based On Cell Reference And Drop Down List

    Hi JohnTopley,
    The spreadsheet is now attached. Thanks

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    27,999

    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
    Attached Files Attached Files
    Last edited by JohnTopley; 04-20-2021 at 10:54 AM.

  5. #5
    Registered User
    Join Date
    03-02-2020
    Location
    Vancouver, BC
    MS-Off Ver
    Mac 2016
    Posts
    5

    Re: Pricing Based On Cell Reference And Drop Down List

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 01-04-2019, 03:32 PM
  2. [SOLVED] show data of reference cell instead of drop-don list
    By adeel1 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-05-2017, 09:43 AM
  3. Change reference cell in formula based on selection in drop down list
    By devin.fentie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2016, 03:40 AM
  4. Cell reference from drop down list
    By seanpmac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-26-2014, 07:33 PM
  5. [SOLVED] Cell reference based on another cell choice from a drop down list.
    By enoch5939 in forum Excel General
    Replies: 2
    Last Post: 12-07-2012, 12:04 PM
  6. Excel 2007 : Drop down list Cell reference
    By Schibbinger in forum Excel General
    Replies: 0
    Last Post: 08-22-2011, 03:10 AM
  7. Create drop list jump to reference cell
    By localhost in forum Excel General
    Replies: 5
    Last Post: 12-31-2007, 04:05 AM

Tags for this Thread

Bookmarks

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