Bill

By using the VLOOKUP Function in the to-be-filled-in-cells.

See Debra Dalgleish's site for info.

http://www.contextures.on.ca/xlFunctions02.html

While you're there check out using Data Validation drop-downs for entering
values to lookup.

http://www.contextures.on.ca/xlDataVal01.html



Gord Dibben Excel MVP


On Sat, 30 Jul 2005 06:36:02 -0700, Bill W
wrote:

am making a product spec sheet would like to enter a product number and then
in cells beside have the ingredients be listed (lbs) and a total weight