Thank you for the help it worked perfectly. What Does the "MATCH(1,(" mean in
the below formula?

Thaks
joe


Biff" wrote:

After thinking about it some more, this may be what you want:

=INDEX(Certs,MATCH(1,(PN&Supplier=$K3&$W3)*(Quoted <"Yes")*(Updated<"Yes"),
0))

Biff