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.

The function entered keeps going to #N/A.

Please HELP!!!!

[] Insert Column or Bar Chart v= \begin{tabular}{|c|c|} \hline \multicolumn{2}{|c|}{ R } \\ \begin{tabular}{|c|c|} \hline Registration Goals \\ \hline EventID & RegistrationGoal \\ \hline EVNT-0012 & 70 \\ \hline EVNT-0022 & 40 \\ \hline EVNT-0032 & 25 \\ \hline EVNT-0037 & 25 \\ \hline EVNT-0017 & 20 \\ \hline \end{tabular} \end{tabular} \begin{tabular}{|c|cc|c|c|c|c|} \hline \multicolumn{8}{|c|}{ Goal Met } \\ \hline & \multicolumn{2}{|c|}{20} & 25 & 30 & 35 & 40 \\ \hline Annual Conference & $ & 150.00 & $170.00 & $190.00 & $210.00 & $230.00 \\ \hline Peer Networking & $ & 140.00 & $160.00 & $180.00 & $200.00 & $220.00 \\ \hline Plant Tour & $ & 160.00 & $180.00 & $200.00 & $220.00 & $240.00 \\ \hline Survey/Study & $ & 120.00 & $140.00 & $160.00 & $180.00 & $200.00 \\ \hline \end{tabular} \begin{tabular}{|c|rr|c|c|c|c|} \multicolumn{8}{|c|}{ Promote Event } \\ \hline & \multicolumn{2}{|c|}{20} & \multicolumn{1}{|c|}{25} & \multicolumn{1}{c|}{30} & 35 & 40 \\ \hline Annual Conference & $ & 100.00 & $120.00 & $140.00 & $160.00 & $180.00 \\ \hline Peer Networking & $ & 90.00 & $110.00 & $130.00 & $150.00 & $170.00 \\ \hline Plant Tour & $ & 110.00 & $130.00 & $150.00 & $170.00 & $190.00 \\ \hline Survey/Study & $ & 70.00 & $90.00 & $110.00 & $130.00 & $150.00 \\ \hline \end{tabular}