I have 2 drop down lists. #1 is a material, #2 is a size.
Based on the selection of #1 and #2 and input of square feet, I need to calculate the weight of material needed.
I have 2 drop down lists. #1 is a material, #2 is a size.
Based on the selection of #1 and #2 and input of square feet, I need to calculate the weight of material needed.
yes fine,so is there a table constructed of weight of material to square feet?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
yes, each material has its own sheet of data. These sheets include sizes and weights per square foot.
See if attached is close to what you are looking for
the Formula in b6 on sheet3 is the workhorse:
Formula:Please Login or Register to view this content.
the rest is just hastily thrown together to give you an idea of what it could look like
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
I've attached the file. I would like to do a calculation in cell C9, but I'm lost
My answer was based on that statement, the principles of the answer are still the same, the formula's are probably less complex now that there is something to work with...
I am truly not sure I want to spend more time on this, the mockup, no answer, then this ..why could you not include in the first post?
Last edited by dredwolf; 11-07-2013 at 01:40 AM.
sorry I reverted the file to al the weights on 1 page. Does that help or hinder? I can put them easily back to their own page.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks