SOLVED

Formula Help Drop Down List Populate Totals

New Contributor

This is for construction and populating the total tonnage per the Square Yardage quantity.  It starts with the Square Footage then automatically populates Square Yardage, which is what all of this criteria is based on.  The criteria are Material & Thickness.  The answer to this scenario is 253 Tons, but unsure of the formula to auto-populate 253 tons under the "TONS" box?  I would like to be able to choose from the 4 different types of material, and 16 different types of thickness to get the correct corresponding tonnage that meets the selected criteria.  Can anyone please help?

 

https://lakeridgepavingcompany-my.sharepoint.com/:x:/g/personal/jsprouse_lakepav_com/EfZ1HpKggkpJlAG... 

2 Replies
best response confirmed by JWS7 (New Contributor)
Solution

@JWS7 

In E6:

 

=INDEX($I$6:$L$21,MATCH(D6,$H$6:$H$21,0),MATCH(C6,$I$5:$L$5,0))

Thank you very much!