Forum Discussion

kieran durrant's avatar
kieran durrant
Copper Contributor
May 01, 2018

Adding a value to a drop down menu item in a list.

I have created a spreadsheet to help me with my photography pricing. I have my Photography Packages which have a set value but with each package are addons that have there own prices (I.e. prints, canvas etc) I want the drop down menu under each package so when I select a product to add to the package the name shows up but there is a value that is added when totalled. 

Each product is in drop down list but I need the value of each one to add up at the bottom! please help

 

these are the products and prices I want assigned to each product.

 

thanks

 

Kieran 

Formulas & Functions
Need Help

2 Replies

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    Jun 08, 2018

    Hey Keiran-

     

    Just wanted to follow up and see if you were able to resolve your issue.  If you have additional questions or inquiries regarding this question or any other please feel free to post them to the Excel Community.

  • Matt Mickle's avatar
    Matt Mickle
    Bronze Contributor
    May 03, 2018

    I would suggest taking the following steps:

     

    1. Create a lookup table 
    2. Add a helper column to translate the descriptions to prices by using the Vlookup() function
    3. Hide the helper column

    Please see attached for an example file of how to accomplish this task.

Resources