Calculation of total Profit
In H5, formula copied down :
=(F5-VLOOKUP(D5,Cost!$B$4:$C$6,2,0))*E5
Regards
you can to use this
Code:=G5-($E5*VLOOKUP($D5,Cost!$B$4:$C$190,2,0))
Calculation of total Profit
In H5, formula copied down :
=(F5-VLOOKUP(D5,Cost!$B$4:$C$6,2,0))*E5
Regards
you can to use this
Code:=IFERROR(G5-($E5*VLOOKUP($D5,Cost!$B$4:$C$190,2,0)),"")