How to add value (£) to worded cells?
My objective is to find the total value of a customisable product.
1. The top right table with the attributes, each need to have a monetary value, ie tall = £10, wide =£20 etc
2. In the third table, with the combinations, it needs to be printed out in another table so the string looks like this:
Tall-Black-No-No-No-No-No
With each attribute separated with a hypon.
3. Finally, I'll need to find the total value of that string.
I've tried racking my brain to figure out how to do this, but I am just not making any progress. I hope someone will be able to help!
many thanks in advance!
________________________________________________________________________________ __________________________________________________
Materials:
Formulas provided by Wayne
https://www.dropbox.com/sh/fzpc69aya48qftj/AABYxu0BpAhupXBFCz8P_qHfa
iMac (27-inch, Late 2012)