I have 11 different values so a nested IF function will not work. I have heard VLOOKUP suggested but I don't think it's what I need.

I have 11 different categories for grouping items. Depending on which category it is, it has a certain formula. For example, if column D says 1, then what's in column G needs to be multiplied by 90%, if it says 2, then it needs to be multiplied by 80%, etc. This needs to happen down the rows. Vlookup just seems like it couldn't handle this.

Any help or suggestions?