Search column for multiple strings

I'd like to add a column in my spreadsheet that will search another column of data for various strings, reporting either "Present" (if any one of the strings is present) or "ABSENT" (if none are). Specifically, the column to be searched will have address information (e.g., "123 Oak Drive"). I'd like to use a formula to search each cell in the address column for various address components (e.g., "Road," "Drive," "Avenue," "Boulevard"). I want the search to not be case-specific, so I'm guessing it will involve the "SEARCH()" command. As my thinking goes, the formula would involve both ISERROR, SEARCH, and OR (to indicate more than one search term), but I haven't been able to figure out anything that works.

Here's a little example of what I'd like the formula to do (assuming the search formula in the "Check" column includes the terms "Drive," "Avenue," and "Boulevard"):

Address	Check
123 Oak Drive	Present
25 Wesley Avenue	Present
64 1st Boulevard	Present
65 Chalmers	ABSENT

Any help you could provide would be greatly appreciated.

Thanks! This is really close! The only problem is that "FIND" is case sensitive, so if an address has "avenue" instead of "Avenue," it still shows up as "ABSENT." Know how to make this insensitive to case?

Perfect! Many thanks!

I wonder, though, is there some way to just list a bunch of search terms in a single column (e.g., column F) and have the program search each cell of a different column for all terms that appear in the range F1:F25? The solution you offered certainly works, but I'm wondering if there's an easier way that just involves listing search terms rather than adding all the additional text to a single formula.

Yeah, that'll work. Thanks again!