Why don't you tell us what you are attempting to do with an example *and*
the expected result?

Biff

"ExcelMonkey" wrote in message
...
Yes this works but I just realized that this does not work they way I need
it
too for duplicates. So if my example has a duplicate in Range 2 (i.e.
"Rain")
the result will look like {1,0,0,0,0,1,0,0,0,0} - as it should. But I
would
need it to look like this {1,0,0,0,0,2,0,0,0,0} which is no longer boolean
as
I originally suggested. How would I incorporate this to accomodate the
duplicate? Remember I want to put it into a SUMPRODUCT function.
SUMPRODUCT({1,0,0,0,0,2,0,0,0,0}, OtherRange). I need to incorporate a
countif into the array.

Thanks

EM

Assume Range 1 is as follows (A1:A10):
Dog
Cat
Man
Women
Car
Rain
Black
In
Peter
Acid

Assume Range 2 is as follows (A12:A16):
Rain
Blue
Rain
Stick
Dog

"T. Valko" wrote:

This will evaluate to that array:

--(ISNUMBER(MATCH(A1:A10,A12:A16,0)))

What are you trying to do?

Biff

"ExcelMonkey" wrote in message
...
Apologies for the re-post. Need to clarify this to avoid confusion.
Is
is
possible to compare two ranges and return a list of booleans
illustrating
where the values in one range reside in the other.

Assume Range 1 is as follows (A1:A10):
Dog
Cat
Man
Women
Car
Rain
Black
In
Peter
Acid

Assume Range 2 is as follows (A12:A16):
Rain
Blue
Mary
Stick
Dog

In cell A17, I want to insert a SUMPRODUCT function. For the first
range
variable of the SUMPRODUCT, I want to illustrate where the items in
Range
2
reside in Range 1 as follows. {1,0,0,0,0,1,0,0,0,0} showing that both
"Rain"
and "Dog" reside in Range 1 in positions 1 and 6. The the first range
in
the
SUMPRODUCT function would look like this if you highlighted in and hit
F9:

SUMPRODUCT({1,0,0,0,0,1,0,0,0,0}, Range2)

Any ideas on what type of logic I would use within this SUMPRODUCT
function
to create the boolean data above?

Thanks

EM