Click cell C$11$ and insert a VLOOKUP function that looks up the code in cell B$11,$ compares it to the codes and types of art in the range $B2$:$C6,$ and returns the type of art. Copy the function in cell $C11$ to the range $C12$:$C59.$ Use relative and mixed $($or absolute$)$ references correctly.