Formula to Populate Cells

[Bob]

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.

 

[PCLIVE]

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

 

[PCLIVE]

Forgot to mention. When you create the table on Sheet2, the lookup column
(parts in column A) needs to be in Ascending order.

--

 

[Bob]

Thanks, what I need though is for example if a Part in Column A contains a
specific
word or number that it will be equal to a specific product category in
Column B.
For example, Column A would have this as a part Number:
1-1/4" X 22-1/2" CLASS L SS I would like to populate Column B with a
specific category based on the word CLASS. If column A contains the word
CLASS then Column B would equal the product category.