How to addd two lists together to create value

**HALEYWARD** · 02-27-2020, 03:37 PM

Hello!

I am trying to create a new template for my business and I cannot figure out how to 1) use one list to only filter certain options and then 2) to add both lists together to create a value.

Example: we sell sheds

I have made a data validation list for the "style" of shed.
If you were to choose one "style" I need the "size" drop down list to only show the sizes for that one particular style.
Then I need the two lists to add together to create a base price.

So if a customer wanted THE HERITAGE in a 8x8 I need the base price at the bottom to show $2200

Please Help! I have attached my template for reference

**mehmetcik** · 02-28-2020, 02:52 PM

What you have asked for is possible. But very unpracticable. Ie unusable.

So I have modified your file for you.

I have inserted Data Validation in cells C14 and E14

I inserted a formula in F14 =IF(INDEX(Sheet1!$A$1:$F$44,MATCH($C$14&"x" &$E$14,Sheet1!$A$1:$A$44,0),MATCH($B$14,Sheet1!$1:$1,0))=0,"Not Available","")

I inserted a Formula in B24 =INDEX(Sheet1!$A$1:$F$44,MATCH($C$14&"x" &$E$14,Sheet1!$A$1:$A$44,0),MATCH($B$14,Sheet1!$1:$1,0))

I then inserted Conditional formatting in A14 to F14 using the formula =$F14 = "Not Available"

Finally I Right Clicked on "Invoice" at the bottom of Excel and created this code for you.

Please Login or Register  to view this content.

**HALEYWARD** · 03-03-2020, 12:49 PM

Thank you so much for your help! I am very new to this forum so I am not completely sure how it works, is the spreadsheet you updated in another file? When I download the one I attached I do not see any revisions. I know I could copy and paste but I would like to see how you placed the formulas.