$10$ Note: Do NOT use an array formula$/$function for this step. See Note $8$ from Step $1$ above.

First Resource pays out a bonus to the coordinator of each event based on the type of event, the total number of registrants and whether or not the registration goal was met. Bonus amounts can be found in either the Goal Met Bonus Amounts or Promote Event Bonus Amounts tables $($depending on which table is applicable to the event$).$

On the Event Analysis worksheet, in the Bonus column, enter a nested function that will return the bonus amount the event coordinator will receive.

Format the result in Accounting number style and fill the function down to the end of the data set.

Hint: You should have $4$ nested functions: INDIRECT, INDEX, MATCH, MATCH $($not necessarily in that order$).$

The INDIRECT function will be the array argument for the INDEX.

For MyLabIT grading purposes, your cell references for the lookup arrays in both MATCH functions should come from the Goal Met table. $14$