Thank you, this works great.
But is there a way to maybe use a range that includes the planes. Because
somtimes I have alot of plans that need to be checked.

"Jason K" wrote:

I am looking for a formula that I can use to look up rows that have a certain
criteria, and is outside a certain date range.
Ex. I want to find all rows that contain Plans 43Z1C1, 43Z2C1, 43Z4C1, &
43ZLC1 and are outside the date range of 12/01/1995 - 12/31/1998 The rows are
set up similar to below:

POLICY CLAIM PLAN EFF DTE INCURRED
--------------------------------------------------------------------
HL01429 532000 49Z4F1 3/19/1999 3/19/1999
HL01431 910700 45Q4A1 3/27/1999 4/8/2009
HL01429 701800 47Z4A1 4/1/1999 10/2/2006
HL01432 910602 47Z4A1 5/25/1999 11/14/2008
HL01432 804906 49Z4A1 5/28/1999 5/7/2006
HL01435 629000 49Z4A1 8/1/1999 3/1/2006

There are about 500 rows, and would only like to find the rows meeting the
criteria similar to about so i can move them to another location.
Thank You