Creating a SUM when choosing a option from a Drop Down List

Create a tab (sheet1) with each of these formula as column A Options "Power Tools etc." and Column B Formula itself.

Then on cell G2 type this.

=VLOOKUP(D2,Sheet20!A:B,2,FALSE)