Forum Discussion

Kiran_gandhi610's avatar
Kiran_gandhi610
Copper Contributor
Apr 10, 2022
Solved

Formula Help

Hello,   Can someone help me to update a discount value for the below table and please share the formula for the revenue also.     Thank you, Kiran
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Apr 10, 2022

    Kiran_gandhi610 

    Please share a screenshot that shows the row numbers and column letters. Even better, share a sample workbook through OneDrive, Google Drive or similar.

HansVogelaar's avatar
HansVogelaar
MVP
Apr 10, 2022

Kiran_gandhi610 

Thanks for sending the sample workbook. In E18:

=INDEX($H$5:$K$7,MATCH(C18,$G$5:$G$7),MATCH(B18,$H$4:$K$4,0))*D18

Revenue will be calculated automatically with the formula you already have.

Resources