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-

D	E
A100	A101
D202	B100
Z400	A103

<tbody>
</tbody>

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!