stupid me! Here is a simple and fast one:

=IF(COUNTIF(Sheet3!$CA$12:$CT$20,Sheet3!G1),Sheet3 !G1,"")

Regards,
KL



"KL" wrote in message
...
...or this array-entered (if the values are numbers):

=OR(Sheet3!G1=Sheet3!$CA$12:$CT$20)*Sheet3!G1

KL


"KL" wrote in message
...
Hi,

The MATCH function doesn't work on bidimensional ranges. Try this
array-entered (Ctrl+Shift+Enter) formula instead:

=IF(OR(Sheet3!G1=Sheet3!$CA$12:$CT$20),Sheet3!G1," ")

or this non-array formula:

=SUMPRODUCT(OR(Sheet3!G1=Sheet3!$CA$12:$CT$20)*She et3!G1)

Regards,
KL


"Luke" wrote in message
...
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