Thank you for your prompt response. The post by Duke Carey was more help to
me as he guided me through the vlookup process in a way a beginner like me
can understand. I have also repsonded to his post as it did not automate the
process the way I am hoping.
--
ray


"Ken Wright" wrote:

Take a look at VLOOKUP and use 5 of these in 5 consecutive cells, with each
one referencing the same cell (The first of the 5 which you will put the
Product code in) and returning the next piece of data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------Â*------------------------------Â*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------Â*------------------------------Â*----------------




"rayteach" wrote in message
...
I am using Excel XP. I have a spreadsheet with product codes, textual
description, price, and extension as the column labels and about 15
records.
I want to know if there is a way to (for example) enter the product code
of
an item in a cell in another worksheet (or a different workbook) and have
the
complete record of that item be duplicated.
ray