link word to a number

[steve]

how can i link a a named product with a number .I use certain chemicals with
different density .they are stored in storage bins of the same size ,i would
like to link the product name with its density and create a spread sheet .how
can i link the two so that were ever the product appears so does the density.

[davesexcel]

how can i link a a named product with a number .I use certain chemicals with
different density .they are stored in storage bins of the same size ,i would
like to link the product name with its density and create a spread sheet .how
can i link the two so that were ever the product appears so does the density.

Hi, Steve,
A simple VLOOKUP sheet would work fine in this situation,Maybe even just a LOOKUP, e-mail me and I will help you with the the particulars
Dave
[email protected]