I want to enter a code into C4 and match that code to a code in another
worksheet and put the corespnding name from that worksheet into cell C3 in
the first worksheet.

Help!!