Product Code and Product Description setup
I'm not sure if I'm doing it right but it does not appear to be working. I
have Excel 2003.
Apparently this has something to do with the 'Lookup' function. I'm not
Let's say you have the product code in column A starting in row 2 in sheet 1
and the description in column B, then you want in sheet 2 to populate the
description when product code is entered in cell A3, so in cell B3 in sheet 2
adjust range to fit you needs but remember the range has to be the same in
both sides of the formula
if you are using excell 2007 use
Hello. I have a worksheet that contains one column for Product codes and the
second coloum contains the product description.
How can I set up a system in another worksheet whereby if the product code
is entered into one cell, the corresponding product description is
automatically entered into the cell next to it?