I've tried what you said.. but it's probably up to me, and I can't get
it to work.. I'm not so good with excel

So, I'll try to be more specific..

Sheet1
A1 - Code (A2 - A.. actual codes)
B2 - Product name (B2 - B.. actual names)

(This sheet has the list of 500 codes with names)

Sheet2
A1 - Code
B2 - Product name
(C3 - Quantity)

So.. I want to add quantity in Sheet2 and to put only a code.. and I
want formula to find a product name for the code..


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