SOLVED

Formula Help

New Contributor

Hello,

 

Can someone help me to update a discount value for the below table and please share the formula for the revenue also.

 

Kiran_gandhi610_0-1649550719498.png

 

Thank you,

Kiran

3 Replies
best response confirmed by Kiran_gandhi610 (New Contributor)
Solution

@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.

@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.

Thank you so much @Hans Vogelaar.