Hi there.

I really dont use Excel much, I've used only the basic functions but I
would like to make a spreadsheet that depending on a catalog number
that I input I would get the product family it is part of.

for example.

I have 3 Families: Screws, Connectors & Rawstock
each family have a bunch of products, which are represented with a
catalog number.

ie.

abcd001
acdb999
etc...

so, I would like to have 2 columns....

Column A which will be Catalog number and Column B which will be
Product Family.

So I would like to input manually the catalog number and by reading the
first 4 letters from the catalog Excel will display automatically the
product family it belongs to on column B.

each of my product families have almost 20 variations.
I have around 10 or 15 product families, how can I make this work?

what command/function do I need?
Please advice. Thanks in advance.