Thanks everybody. I surprised myself and figured it out before I got your
comments. This was just the first step in the process to retrieve the data.
I'll be back in touch, but I sure appreciate your help. Thanks again.

"Harlan Grove" wrote:

Bob Phillips wrote...
....
=IF(A2={"Closed","Failed","Implemented","Imp(d)"} ,"Copy","")
....
"pomalley" wrote in message
My spreadsheet contains more than 3000 records. I want to retrieve
only
those records whose status is Closed, Failed, Implemented, or Imp(d);
....

Looks like Bob forgot an OR() call. Try

=OR(A2={"Closed","Failed","Implemented","Imp(d)"})

and filter on TRUE values.