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

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

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

--

"PCLIVE" wrote in message
...
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

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.

--
Bob


"PCLIVE" wrote:

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

--

"PCLIVE" wrote in message
...
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