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?