Adjust the equation to get the correct value

[Hany ali]

Hello My Master ,I want Your Help To Correct This equation which in Column U According to what is mentioned in the column V As Result

=$B2*INDEX(Data!$AC$3:$AJ$24,MATCH($F2&$E2,Data!$A$3:$A$23,0),MATCH($Q2,Data!$AC$1:$AJ$1,0))+$C2*INDEX(Data!$AC$3:$AJ$24,MATCH($F2&$E2,Data!$A$3:$A$23,0),MATCH($Q2,Data!$AC$1:$AJ$1,0))

To get Correct Information From Data Sheet

 

[bosco_yip]

Try,

In W2, formula copied down:

=ROUNDUP(SUM(VLOOKUP(F2&E2,Data!A$3:AJ$23,MATCH(Q2,Data!$1:$1,0)+{0,1},0)*B2:C2),2)

 

[Hany ali]

Thank you very much for your efforts, and I am very grateful for your help. This is really what is required of you. Thank you very much. You are a genius.