Sorry, xor and thanks for the continued replies. "Plant down" is the value that should be returned when the date range, in this example, from A12
12 falls within the date range that the plant was down (9/3-9/13). However, the date values in cells A12:C12 are 10/10-10/16 in which case, then "ASN data issues" should have been returned as that is the date range that contains dates between 9/14-10/31.