Percentage Work

Hi all, Good day!!

Need help in Excel formulas.

I'm creating a workbook to counting a value in multi percentage and multi level.

Here I attached my print screen sample workbook.





I need to set when I select TYPE in list then the calculation auto read the percentage in need.

e.g.:

when the column D type is " B " so the percentage is 1.2% then column F formula help me count the value like amount in 300 then column F showing 3.60 which get from 300 x 1.2% and column G & H is 0 value. If the type change to M then the column F & H become 0 value and column G count 300 x 1.7% value.

I also create a table for the TYPE list.

At the Column F,G & H I used the formula as below but didn't work at all :( it will show the percentage value in both column.

=IF(OR(D2="", E2=""), "", IF(ISERROR(VLOOKUP(D2,L$2:L$6,1,FALSE)), "", E2 *VLOOKUP(D2,L$2:M$6,2,FALSE)))


Thank you.