Check the help for the VLOOKUP function, it may fit your needs on this
scenario.

Hope this helps,
Miguel.

"Lisa" wrote:

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!!