Need to return an array

[andy62]

I am using this typical array-entered construct in "copy down" mode to
generate a list:

INDEX('All Data'!$B$4:$B$1504,SMALL(IF(AND('All Data'!$X$4:$X$1504=C$37,'All
Data'!$A$4:$A$1504=$C$3),ROW('All Data'!$B$4:$B$1504)-ROW('All
Data'!$I$4)+1),ROWS(C$40:C40)))

I've had to introduce an AND function to test for two conditions inside the
IF statement. I realize AND is not going to return an array, even with the
whole function being array-entered. Is there something I can use instead of
AND to produce a Boolean array: TRUE if both pairs test true, FALSE otherwise?

TIA

 

[Pete_UK]

Multiplicative AND. Instead of:

AND('All Data'!$X$4:$X$1504=C$37,'All Data'!$A$4:$A$1504=$C$3)

try it this way:

('All Data'!$X$4:$X$1504=C$37)*('All Data'!$A$4:$A$1504=$C$3)

Hope this helps.

Pete

 

[andy62]

Perfect, thanks!

Multiplicative AND. Instead of:

AND('All Data'!$X$4:$X$1504=C$37,'All Data'!$A$4:$A$1504=$C$3)

try it this way:

('All Data'!$X$4:$X$1504=C$37)*('All Data'!$A$4:$A$1504=$C$3)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Andy - thanks for feeding back.

Pete