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
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
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 <[email protected]>
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
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 <[email protected]>
> 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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks