I completed the first part which is below:

First Resource offers a bonus to the coordinator for each event. The bonus amount is based on the event type and the number of registrants. In addition, there are different amounts awarded if the registration goal has been met or not. Create a Goal_Met named range for cells H14:L17 and a Promote_Event named range for cells H21:L24.

In cell E4 enter an INDEX function that incorporates the INDIRECT function for the array argument to retrieve the bonus amount the event coordinator will receive. Format the result as Accounting and copy the formula down through E9.

I cannot figure out the index formula please help.

=IF(INDEX(INDIRECT("Goal_Met"),4,3, Goal_Met)) F H j K L M Registration Goal 20 70 C D E 3 TotalRegistrants Action Bonus 4 23 Goal_Met =IF(INDEX 5 66 Promote_Even 6 27 Goal_Met 7 38 Promote_Even 8 21 Goal_Met 9 24 Promote_Even 10 G EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 25 40 20 25 11 12 13 14 Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $160.00 $ 180.00 $ 200.00 $ 220.00 160.00 $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $160.00 $ 180.00 $ 200.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 15 16 17 18 19 20 21 Promote Event 20 25 30 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $ 90.00 $110.00 $ 130.00 $ 150.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 22 23 24 25 26 27 28 =IF(INDEX(INDIRECT("Goal_Met"),4,3, Goal_Met)) F H j K L M Registration Goal 20 70 C D E 3 TotalRegistrants Action Bonus 4 23 Goal_Met =IF(INDEX 5 66 Promote_Even 6 27 Goal_Met 7 38 Promote_Even 8 21 Goal_Met 9 24 Promote_Even 10 G EventID EVNT-0037 EVNT-0012 EVNT-0042 EVNT-0022 EVNT-0017 EVNT-0032 25 40 20 25 11 12 13 14 Goal Met 20 25 30 35 40 150.00 $ 170.00 $ 190.00 $ 210.00 $ 230.00 140.00 $160.00 $ 180.00 $ 200.00 $ 220.00 160.00 $ 180.00 $ 200.00 $ 220.00 $ 240.00 120.00 $ 140.00 $160.00 $ 180.00 $ 200.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 15 16 17 18 19 20 21 Promote Event 20 25 30 35 40 100.00 $ 120.00 $ 140.00 $ 160.00 $ 180.00 90.00 $110.00 $ 130.00 $ 150.00 $ 170.00 110.00 $ 130.00 $ 150.00 $ 170.00 $ 190.00 70.00 $ 90.00 $110.00 $ 130.00 $ 150.00 Annual Conference $ Peer Networking $ Plant Tour $ Survey/Study $ 22 23 24 25 26 27 28