---------------------------
SAMPLE SHEET
---------------------------
ORGANIZATION | ADDRESS |
Franklin County DJFS |123 E. Main St. Columbus,OH|
Madison County DJFS |123 S. Lucas St. London, OH|
Guernsey County DJFS |4442 E 33rd St. Blahblah,OH|

I am trying to assign each entry to 1 of 8 regions based
on the county named in COL A. Is there a way (I tried
using [IF(FIND(OR("text","text"),A2)=1,"...] to search
for one of multiple strings within a string? For
example 'Franklin' and 'Madison' are both assigned to
the 'Central Ohio RTC' and 'Guernsey' is 'East Central
RTC', etc.

Any assistance would be GREATLY appreciated.

Thanks,
Chris