LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Formula to Populate Cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to Populate Cells nejohnso76 Excel Discussion (Misc queries) 1 September 27th 07 01:25 AM
Creating a formula to populate information from multiple cells in another workbook Sullycanpara Excel Worksheet Functions 8 June 30th 06 04:17 PM
Help! Formula that can Ref. hidden data & Populate Cells with desired text [email protected] Excel Worksheet Functions 1 April 8th 06 06:12 AM
Auto populate cells based on 2 cells division. Chance224 Excel Discussion (Misc queries) 0 April 4th 05 09:35 PM
How to populate formula in range of vertical cells to next colum Robert Excel Worksheet Functions 0 November 17th 04 05:09 AM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"