Another function needed

[Jean]

I submitted a question similar to this, but now I need
more detail.

Take ALL the numbers in Column B and find a match in
Column A. I need a formula in Column D that would
determine if any number in B matches any number in A, is
there a 1 in Column C.

A B C D
765 765 1
768 768 2
770 768 1
768 770 2
765 771 2

 

[Vasant Nanavati]

Hi:

=AND(NOT(ISNA(MATCH(B1,A:A,0))),C1=1)

Copy down.

Regards,

Vasant.