Forum Discussion

Amanda Rotger's avatar
Amanda Rotger
Copper Contributor
Jul 30, 2018

Need help with formula

Good morning,

 

Looking to make a billing spreadsheet that will eliminate the need for manual entries.

 

1) I am looking to take the data from cell C3 and E3 on my "template" sheet, and compare it to cells A2-F6 on my "Pricing List" sheet.

 

2) Then, the formula should take that data and give me the price associated with those two cells in cell F3 on the "template" sheet.

 

         EX: "template" sheet shows 8' black drape prestrung so therefore i would like it to represent cell C2 from the "pricing list" sheet in F3 on the "template" sheet.

 

 

Please see files attached.

excel
Formulas and Functions

3 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 30, 2018

    Hi Amanda,

     

    To simplify your data structure as

    the formula in L2 for the price will be

    =IFERROR(INDEX($B$2:$G$7,MATCH($I2,$A$2:$A$7,0),MATCH($J2,$B$1:$G$1,0)),0)*K2

    You may adjust to your actual ranges.

    Attached

     

Resources