Add a column to your lookup table with the percentages ( say it is the 3rd column) then =IF(C34<>"",H16*VLOOKUP(C34,Table7_Percentage,3,FALSE),"")

PS the SUM function in your formula is not necessary

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post