say your dropdown list is on sheet 1 A1 - - - your product codes are on
sheet 3 B1:B163 and description on sheet 3 C1:C163
on sheet 1 B1 =index(sheet3!$C$1:$C$163,match(A1,sheet3!$B$1:$B$ 163,0))
--
grizz


"thelma68" wrote:

I am trying to set up a billing spreadsheet. On one spreadsheet I have a
list of product codes in one column, the description in the next column and
the price in the third column. On another spreadsheet I would like to pick
the appropriate code from a drop-down list (no problem with that) and I would
like the description and price to fill in automatically once I choose the
code. I thought this would be easy but I am stuck!! Having drop down lists
in each column is not an option since there are 163 things in each drop down
- the descriptions are wordy and I want to garantee I get the right
description with the corresponding code.

I have used excel since day one but I am out of practice. Any help is
greatly appreciated.

Thanks,
cheryl