Leith,
Awesome, thanks for the quick reply, it works perfectly!

One more question, how would you make this more generic, i.e. allow entries into the formula for the range and the responses. Say we call the formula ISWORD() with the following entries: search cell, range of desired words, response if true, response if false

Thanks again,

Tom