Forum Discussion

JWS7's avatar
JWS7
Copper Contributor
Aug 23, 2022
Solved

Formula Help Drop Down List Populate Totals

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 cr...
  • HansVogelaar's avatar
    Aug 23, 2022

    JWS7 

    In E6:

     

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

Resources