match on multiple columns

[amirf]

Hi,
i have a list of items on column A, for example -

A100
A101
B100
C100
D202
A103

and another list of items in range D1:E10
the list in the range contains multiple items in different order than the original list. (partial) example-
[TABLE="width: 500"]
<tbody>[TR]
[TD]D[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]A100[/TD]
[TD]A101[/TD]
[/TR]
[TR]
[TD]D202[/TD]
[TD]B100[/TD]
[/TR]
[TR]
[TD]Z400[/TD]
[TD]A103[/TD]
[/TR]
</tbody>[/TABLE]



i need to validate that the items in column A are present in the range B1:C10

i tried : in cell B1 (and copy down) => =ISNUMBER(MATCH(A1,D1:E10,0))
and also tried naming the range and using an array formula: in cell B1 (and copy down) => =ISNUMBER(MATCH(A1,range,0))

both formulas didn't work

Thanks

 

[steve the fish]

Can use this:

=COUNTIF(D:E,A1)>0

 

[amirf]

Can use this:

=COUNTIF(D:E,A1)>0

Brilliant!

Thanks!