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
|