On Sheet2, create a table with your parts in column A beginning in row 1 and
the corresponding category in column B. Then on your other sheet, use this
formula in B1.

=VLOOKUP(A1,Sheet2!A1:B10,2)

You can adjust the range of A1:B10 as needed.

HTH,
Paul

--

"Bob" wrote in message
...
I've got a column part table - column A is the Part name and Column B is
the
Product Category. I add to the part column monthly and would like to have
a
formula in column B that if column A contains a specific word that it
would
be equal to a part category in column B. I could also have the 8 product
categories in a separate sheet so I could reference them in the formula.


Thanks.
--
Bob