Matching value in two arrays

It sounds like you area actually comparing ranges, not arrays.
If that's true, then...
With

range_1 (A1:C1) containing 1,2,3
range_2 (F1:H1) containing 2,3,5
range_3 (K1:M1) containing 5,6,7

This formula returns the first range_1 value with a corresponding value in range_2:

=IF(SUMPRODUCT(COUNTIF(F1:H1,A1:C1)),INDEX(A1:C1,MATCH(1,INDEX(COUNTIF(F1:H1,A1:C1),0),0))
,"no match")

This one compares range range_2 to range_3:

=IF(SUMPRODUCT(COUNTIF(K1:M1,F1:H1)),INDEX(F1:H1,MATCH(1,INDEX(COUNTIF(K1:M1,F1:H1),0),0))
,"no match")

and this on compares range_1 to range_3:

=IF(SUMPRODUCT(COUNTIF(K1:M1,A1:C1)),INDEX(A1:C1,MATCH(1,INDEX(COUNTIF(K1:M1,A1:C1),0),0))
,"no match")

In the above example the formulas return these values:
2
5
No match

Is that something you can work with?