On Fri, 15 Apr 2011 18:13:43 -0700 (PDT), wrote:

Thanks How can I modify this to give the text exactly 2 columns (or
whatever number of columns) over from the match? Like how 'vlookup'
works. Is it possible to modify this to deal with blank cells or will
it get way too complicated?

Your column of words "WordList" is where ever you put it. If your phrases are in column A, and your list of words is in Column C, just use C1:Cn as the argument.