I need a formula (IF maybe) that will result in an increase amount. I have
several types of service care (I,II,III) as drop down option on column G.
Those same types of service have been assigned a percentage (1%,2%,3%) on
column AF
For example, If someone selects service care "I" the formula should locate
the respective percentage for that level (1%) and then use this percentage to
calculate a dollar amount increase with respect to a dollar amount on column
AA

Column G Column AA Column AF Result
Drop Down 100 1% $1.0
Drop Down 200 2% $4.0
Drop Down 300 3% $9.0