Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula to Populate Cells | Excel Discussion (Misc queries) | |||
Creating a formula to populate information from multiple cells in another workbook | Excel Worksheet Functions | |||
Help! Formula that can Ref. hidden data & Populate Cells with desired text | Excel Worksheet Functions | |||
Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
How to populate formula in range of vertical cells to next colum | Excel Worksheet Functions |