info in cel needs to propt other cels to automatically enter text

[Bill W]

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

 

[Gord Dibben]

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

 

[Bill W]

Thanks Gord that works perfect!!!!

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