@ tiger i've slept with this(logic the op wants) last night, then i look at your formula above "shorter to get first word i and came up with this..
the word cooperative is the second key word to find. so in B14 the word "Beanster Company" becomes - "Beanster Cooperative" because we are searching if Beasnter is a cooperative in the search area.
@ tech - now the problem here is if the word to search starts with "The" it becomes the first word..
e.g. The Beanster Company...
the above formula then will have the word words to search as " The Cooperative" so this is wrong.
if you could post a sample of the Company names maybe we could have options to exclude some words...
btw i didn't have time to verify the formula for other samples.
thanks.
hth..
Bookmarks