Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VB Question
We are looking to make a VB that will look in one column, and based
upon text found, place a set word in another column. For example, column B will contain the text "ABC-123 Sheeting - 25ft" and we need it to place "Docks" in column C. If column B contains "ADC-234 Decking - 5ft" we need column C to autofill with "Decks". There would be 3-4 other rules. How would we go about doing this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VB Question
=IF(B1="ABC-123 Sheeting - 25ft","Docks",IF(B1="ADC-234 Decking -
5ft","Decks","Unknown")) " wrote: We are looking to make a VB that will look in one column, and based upon text found, place a set word in another column. For example, column B will contain the text "ABC-123 Sheeting - 25ft" and we need it to place "Docks" in column C. If column B contains "ADC-234 Decking - 5ft" we need column C to autofill with "Decks". There would be 3-4 other rules. How would we go about doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel question | Excel Discussion (Misc queries) | |||
Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
New to Excel with Question | New Users to Excel | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |