The formula found in E5 below, the IF(A6="Total",1, portion is the only pertinent part as the rest works fine. I just want to replace the 1 with some a method that would work as above and be simple to copy allowing me to add things to the sheet over time.

=IF(A6="Total",1,VLOOKUP(B6,Ingredients!$A$1:$AG$29,3, FALSE)*$C$2)