On Apr 18, 1:41*pm, Ron Rosenfeld wrote:
On Mon, 18 Apr 2011 06:43:51 -0700 (PDT), wrote:
How can this be modified to deal with blank cells in the 'wordlist'
column?

Thanks!

I don't know how to modify the formula to do that. *Perhaps some lurker can figure it out, if it is possible.

I would either use a VBA User Defined Function, or, if that is not allowed by your company, I would ensure that there are no blank cells in WordList.. *

The VBA UDF would be based on what I presented in my second response to you a few days ago. *If that is what you want, you can either modify it yourself or, if you will present a full list of specifications in a single message, (as opposed to one new specification per message, which is what you have been doing), I would be happy to make the appropriate modifications.

Not knowing what I was doing I made this modification based on
searching around the net. =IF(ISNA(MATCH(TRUE,ISNUMBER(SEARCH($C$2:$C
$26,A2)),0)),"",INDEX($E$2:$E$26,MATCH(TRUE,ISNUMB ER(SEARCH($C$2:$C
$26,A2)-COUNTIF($C$2:$C$26,0))),0)

This just gives me the last text in the list instead of not counting
the blank cells. I may look into modifying that UDF posted earlier
however, I don't think it was written to return the text that was x
number of columns over from the match so I don't think I'll be
successful at modifying it. :)