You now have 3 people who say they don't really understand what you
want to do - can you explain things a bit more clearly? For example, if
you do have the word "the" in A1, what do you want to do with it? What
should happen if "the" is not present? What is the "list" that you
refer to? We can't really help you if we don't understand what the
problem is !!

Pete

Multiple IF''''s with Vlookup wrote:
I think i am very close now.

Could you please let me know how to use Multiple IF's in the same example

=IF(COUNT(SEARCH(MID(" "&A1&" ",FIND("the",A1)+{0,4},1),
"ABCDEFGHIJKLMNOPQRSTUVWXYZ_0123456789"))=0,"yes", "no")


(This is a good example)