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 B$2$:C$6,$ and returns the type of art. Copy the function in cell C$11$ to the range C$12$:C$59.$ Use relative and mixed $($or absolute$)$ references correctly.