7. Using Excel Vlookup formula, to look up the AL taken information from "Data" sub-sheet. \begin{tabular}{|l|l|} \hline Name & AL taken \\ \hline Ariel & \\ \hline Berry & \\ \hline Chanelle & \\ \hline Dora & \\ \hline Eden & \\ \hline Francis & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|} \hline Name & MC taken & AL Taken & UPL Taken \\ \hline Amanda & NIL & 3 & NIL \\ \hline Ariel & 0.5 & 4 & 2 \\ \hline Apple & NIL & NIL & 3 \\ \hline Belle & 2 & 0.5 & 1 \\ \hline Benny & 3 & NIL & NIL \\ \hline Berry & 5 & 2.5 & 2.5 \\ \hline Ben & NIL & 3 & 3 \\ \hline Candy & 1 & 5 & 3.5 \\ \hline Carol & 4 & NIL & 4.5 \\ \hline Cherry & 1.5 & 1 & 3 \\ \hline Chanelle & NIL & 3 & 0.5 \\ \hline Daniel & 0.5 & NIL & 5.5 \\ \hline Diana & 2 & 3.5 & NIL \\ \hline Dennis & 4 & 1.5 & 1 \\ \hline Dora & 2.5 & 4.5 & NIL \\ \hline Evan & NIL & 6.5 & 2 \\ \hline Elaine & 4 & 2 & 4 \\ \hline Eden & 3 & 4 & 1.5 \\ \hline Frankie & 10 & NIL & NIL \\ \hline Francis & NIL & NIL & 2 \\ \hline \end{tabular}