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