HELP: Displaying a brand depending on the first 4 letters of a catalog.

[AE]

Hi there.
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
column B.

is it possible? how?

I have between 10-15 product families (ie: screws, connectors,
rawstock, etc)
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:
ABCD001
ABCD099
ACBD001
ACBD099
CDBA234
etc...


the following could be connectors (preffixes like XXZZ, XZXZ, XYZX)
XXZZ001
XZXZ999
XYZX001
etc...

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.

 

[RobertVA]

Hi there.
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
column B.

is it possible? how?

I have between 10-15 product families (ie: screws, connectors,
rawstock, etc)
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:
ABCD001
ABCD099
ACBD001
ACBD099
CDBA234
etc...


the following could be connectors (preffixes like XXZZ, XZXZ, XYZX)
XXZZ001
XZXZ999
XYZX001
etc...

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.

Maybe something like this...

Two databases

Database 1 with two fields:

Headers in first row.

Prefixes first column.

Matching Categories in second column.

------------------

Database 2 with at least three fields:

Headers in first row.

Part number entry in first column.

Formula in cell to extract prefix from text in second column like
"=LEFT(a34,4)" (extracts first four characters from row 34). this column
could be hidden from view.

Formula to match prefix to category with first table similar too
"=VLOOKUP(B34,A$2:B$10,2,FALSE)"

 

[Guest]

Escell will certainly do what you describe. However, you may find a better
forum for your question at the following:
http://search.microsoft.com/results.aspx?q=excel+newsgroup&mkt=en-US&FORM=SSME

Just choose a newsgroup that is relevetn to your needs.

Good luclk