Forum Discussion
kieran durrant
May 01, 2018Copper Contributor
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, ca...
Matt Mickle
May 03, 2018Bronze Contributor
I would suggest taking the following steps:
- Create a lookup table
- Add a helper column to translate the descriptions to prices by using the Vlookup() function
- Hide the helper column
Please see attached for an example file of how to accomplish this task.