Hello World!

I am trying to extract text to the left of several words. The following formula works:

=IF(A15<>"",LEFT(A15,SEARCH("Every",A15)-1),"")

That is, if cell A15 isn't blank, search the cell and extract text before the word "Every."

However, if the word "Every" doesn't appear, but instead one of the following words does appear, viz., "Rental", "Moved", "Move", "One", "Weekly", or "Biweekly", I would need to extract text to the left of that instead.

At first I wanted to just use the following equation:

=IF(A5<>"",LEFT(A5,SEARCH(OR("Every","On","Rental","Move","Moved","One","Weekly","Biweekly"),A5)-1),"")

but after a search on several fora I found out that the OR function doesn't work within SEARCH.

I'm trying to figure out what to do instead. Am I on the right track with the equation below? How would I finish the equation? I want to extract the string to the left of the aforementioned words. Below is what I came up with:

=IF(A5<>"",LEFT(A5, IF(ISERROR(SEARCH("Rental",A15,1)<>0),IF(ISERROR(SEARCH("Every",A15,1)<>0),IF(ISERROR(SEARCH("Move",A15,1)<>0),IF(ISERROR(SEARCH("Moved",A15,1)<>0),IF(ISERROR(SEARCH("One",A15,1)<>0),IF(ISERROR(SEARCH("Weekly",A15,1)<>0),IF(ISERROR(SEARCH("Biweekly",A15,1)<>0),IF(ISERROR(SEARCH("On",A15,1)<>0),...

Thanks!