Cole wrote...
....
What I'm wanting to be able to do is this. I want Excel to search a
column. Within this column are the descriptions of every product. I
want this search to find a particular word within these strings of
text. If the word is not found, then the result would be nothing. If
the word IS found, then I want Excel to do a vlookup on another column
to match that word and return a string of text which would be added to
the description.
....

There are much better tools than spreadsheets for this sort of thing,
but it could be done with a macro. Is there any pattern to your
substrings? Do they always appear inside parentheses or set off by
hyphens? If not, you're going to need to use regular expressions, and
the macro will be slow.