link word to a number
 

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.

link word to a number
 

steve Wrote:
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



--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516650