Click in cell I4, note that you can choose a product from the list. The next three calculations must return the correct values for the selected product. In K4 write a calculation to count how many different part codes are required for the product selected in I4.

\begin{tabular}{l} 4 \\ \hline 1 \\ \hline 3 \\ 4 \\ 5 \\ 6 \\ 7 \\ 8 \\ 9 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline JB Master & Products & 0 \\ \hline \multicolumn{2}{|c|}{} & \\ \hline Supplier & Products & Parts Needed \\ \hlineH&G & 6 & \\ \hline Smithsons & 15 & \\ \hline Parts Plus & 3 & \\ \hline \end{tabular} \begin{tabular}{l} 4 \\ \hline 1 \\ \hline 3 \\ 4 \\ 5 \\ 6 \\ 7 \\ 8 \\ 9 \\ \hline \end{tabular} \begin{tabular}{|l|c|c|} \hline JB Master & Products & 0 \\ \hline \multicolumn{2}{|c|}{} & \\ \hline Supplier & Products & Parts Needed \\ \hlineH&G & 6 & \\ \hline Smithsons & 15 & \\ \hline Parts Plus & 3 & \\ \hline \end{tabular}