Hi Ernie

On sheet2, assuming you have your dropdown in column A, and have
selected a part number in A2, enter the following formula in cell B2 and
copy down as far as required
=IF(A2="","",IF(ISERROR(VLOOKUP(A2,Sheet1!$A:$B,2, 0)),"",VLOOKUP(A2,Sheet1!$A:$B,2,0))

Basically, the formula says, if A2 is empty, show nothing in B2, If
lookup of the item returns an error, show nothing, otherwise look for
the item shown in A2 in column A of Sheet1, and display the item on the
same line from column B of Sheet1.

--
Regards

Roger Govier


"ernie" wrote in message
...
i have this excel document. there are item codes and the discription to
the
items in the same row...items in one column and description in another
column
... for ex:

item code | description
row1 te35434 | nissan brake pad
row2 eos920 | poineer mp3 player


lets say i wanted to have these descriptions automatically display in
another worksheet when ever i select the item codes from a dropdown
list. how
do i go about doing that..

any help would be greatly appreciated..
thanks in advance.

--
help a friend help you