Thanks. I do have one problem. It works fine when there's a value to find but
when there's not value it returns #N/A. How would I fix this?

TIA
Joe

"Biff" wrote:

Hi!

It means that when all these elements are multiplied together:

(PN&Supplier=$K3&$W3)*(Quoted<"Yes")*(Updated<"Y es")

the operation returns an array of 1's and 0's. Something like this:

0
0
0
1
0
0
0

Then:

MATCH(1,{0,0,0,1,0,0,0},0) = 4

Because the matched 1 is in the 4th position of the lookup_array. And then
returns the 4th element of the Index array.

Pretty simple stuff, eh!

Now, can you answer the question I just posted? <g It's related!

Biff

"Joe Gieder" wrote in message
...
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