Formula to Populate Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob - 28 Mar 2008 15:09 GMT

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.

Signature

Bob

Reply to this Message

PCLIVE - 28 Mar 2008 15:49 GMT

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

> I've got a column part table - column A is the Part name and Column B is
> the
[quoted text clipped - 6 lines]
>
> Thanks.

Reply to this Message

PCLIVE - 28 Mar 2008 15:57 GMT

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

> 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
[quoted text clipped - 17 lines]
>>
>> Thanks.

Reply to this Message

Bob - 28 Mar 2008 16:39 GMT

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.

Signature

Bob

> Forgot to mention. When you create the table on Sheet2, the lookup column
> (parts in column A) needs to be in Ascending order.
[quoted text clipped - 20 lines]
> >>
> >> Thanks.

Reply to this Message