See if this example covers your situation

On Sheet1 you have a list.
A1: Code
A2 through A??: code numbers
B1: Name
B2 through B??: names

On Sheet2:

A1: Code
A2: (a code number)

B1: Name
B2: =VLOOKUP(A2,Sheet1!A1:B100,2,0)
(returns the name on Sheet1 that is associated with the code in A2)

Copy that formula down as far as needed

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=501721