Look up and sum costs of selected features
I am building a form and associated sheet/workflows to track requests for vehicles from our customers. I'm hoping to find a formula that would allow me to use features chosen in multi-select columns to look at a different sheet where the costs of each feature are organized, and return the total cost of all the features selected. For example, if the customer selected "amber light bar" and "800 MHz prewire", the formula could look in the source sheet to see the cost for "amber light bar" and the cost for "800 MHz prewire" and sum those costs in my target cell. Too complicated or is this somehow possible?
Help Article Resources
Check out the Formula Handbook template!