Hi,

First, create worksheet, where you list all the item IDs an
descriptions. For Ex. Column A contains the IDs and column B thei
descriptions. Rename this sheet as "Data"

Now go back to the sheet, where you enter product returns and type th
following formula to the cell, where the description supposed to be :

=VLOOKUP(x;y;z)
where
x:= address of the cell, where you enter the ID of the returne
product
y:= address of the table, which contains the ID's and the descriptio
of the products
z:= index of the column to be returned as description from the "Data
sheet (in this case 2nd column)

I also attached an example fil

Attachment filename: examp.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=42230
--
Message posted from http://www.ExcelForum.com