|Subject:||HELP: is there a compare function??|
|Posted by:||AE (alan_estra…@axtel.net)|
|Date:||6 Jun 2006|
I would like some help in building a spreadsheet up....
what I would like to do is have 2 columns (A&B)
Column A will be called CATALOG NUMBER
Column B will be called PRODUCT FAMILY
I would like to manually enter a catalog number in column A and have
Excel to display the product family it belongs to automatically on
is it possible? how?
I have between 10-15 product families (ie: screws, connectors,
each product family has 5 to 20 possible combinations ("prefixes") -
only the first 4 letters will define the product family, the rest will
be a numeric secuencial code-
for example the following numbers could be screws:
the following could be connectors (preffixes like XXZZ, XZXZ, XYZX)
Advice is needed, please help me complete this spreadsheet,
I've used Excel only for its basic (and I mean really basic) functions.
Thanks in advance.