Populating info from another worksheet

[Kelly]

I want to have a source sheet with various product
numbers, names, descriptions, and price per units and be
able to pull up this info into another spreadsheet (or
worksheet) when I type in just the product number, having
it populate all the additional information.

For example: I want to have a product listing sheet, and
then an additional quote sheet. I want to be able to just
type in the first field "product id" and have the rest of
the info populated (name, description, price per unit) so
I don't have to do it manually.

Any suggestions?

 

[mzehr]

Hi Kelly
Check out Debra Dalgleish great web site for some examples
of what you're looking for:

http://www.contextures.com/excelfiles.html#DataVal
HTH

 

[icestationzbra]

if your master list is indexed by product id, then the function VLOOKU
might interest you for your requirement