Hi,

I have a spreadsheet filled with thousands of different inventory
items. Each column represents a characteristic, size, type, product
code. Each row is a different item.

One of our columns is the product code of the same item, only in our
major competitors product line. Our clients often give us spreadsheets
with nothing but a giant column with this competitors product codes.

I need to be able to plug this column of individual item codes into
excell and have it pick out the appropriate items associated with the
code and spit it back out all together.

I can find many ways to put only one product code and getting one
inventory item in return, my problem is that I am unable to find a way
to retrieve many inventory items at a time.

Thanks


--
arieck
------------------------------------------------------------------------
arieck's Profile: http://www.excelforum.com/member.php...o&userid=26321
View this thread: http://www.excelforum.com/showthread...hreadid=395923