Do you mean that if a number in any position in Array2 is included at
least once in any position(s) in Array1, you want it included in the
output list? Are the numbers in Array 2 unique? If not, do you want the
non-unique numbers included more than once in the output list if they
are also included in Array1?

Alan Beban

Luke wrote:
Sheet1 has Array1 = g1:bw10
Sheet2 has Array2 = ca12:ct20

in sheet3 I need to display only the numbers from the range in sheet2 that
are equal to those in the range in sheet1.
I tried:
=IF(ISNA(MATCH(Sheet3!G1,Sheet3!$ca$12:$ct$20,0))= FALSE,"",Sheet3!G1)
filled down and accross as needed
But doesn't display anything even though there are matches.
Can you help me?
Thank you
Luke