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
__________________
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
|