| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
info in cel needs to propt other cels to automatically enter text
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Thanks Gord that works perfect!!!!
"Gord Dibben" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Track info from one w/sheet onto another. | Excel Worksheet Functions | |||
| Can I create a form to run off of info saved on Excel 97? | Charts and Charting in Excel | |||
| Multiple worksheet queries | Excel Worksheet Functions | |||
| vlookup...transferring info from 1 sheet to another.... | Excel Worksheet Functions | |||
| paste info into merged cells | Setting up and Configuration of Excel | |||
Hybrid Mode
