Your references seem to include some typos, but.....

On Sheet2, if you enter a Code in cell A2, then this formula (which I
posted earlier) should return the Product Name associated with that
code:

B2: =VLOOKUP(A2,Sheet1!$A$1:$B$100,2,0)

Adjust the sheet and range range references to suit your situation.

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