Aug 23 2022 09:58 AM - edited Aug 23 2022 11:14 AM
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?
Aug 23 2022 01:15 PM
SolutionAug 23 2022 01:15 PM
SolutionIn E6:
=INDEX($I$6:$L$21,MATCH(D6,$H$6:$H$21,0),MATCH(C6,$I$5:$L$5,0))