MATCH + multiple arguments + OR function

Hello everyone,

I want to use the MATCH function to show the first result that meets 3 conditions in different arrays:
- Condition 1: ARRAY1>0 (give cell positions in array with value greater than 0)
- Condition 2: ARRAY2<10 (give cell positions in array with value lower than 10
- Condition 3: ARRAY3=-2 OR ARRAY3=3 (give cell positions in array with value that equals -2 or 3)
(condition 3: it should select the first TRUE argument of both that also corresponds to a TRUE in the arrays for condition 1 and 2, see example below)

So I do something like this (simplified):
=MATCH(1;(ARRAY1>0)*(ARRAY2<10)*(OR((ARRAY3=-2);(ARRAY2=-3));0)

However, the formula gives a #VALUE error when it calculates the OR function for condition 3, the two separate parts are calculated correctly untill the formula has to actually perform the OR function.

This is an example of a fictive dataset where the match function should return 3:

ARRAY 1, condition 1	TRUE	FALSE	TRUE	TRUE	FALSE
ARRAY 2, condition 2	TRUE	TRUE	TRUE	FALSE	TRUE
ARRAY 3, condition 3 (first OR argument)	FALSE	FALSE	TRUE	TRUE	FALSE
ARRAY 3, condition 3 (second OR argument)	FALSE	TRUE	FALSE	TRUE	FALSE

Can anyone advise me on this? Thank you very much!

Originally Posted by Kaper

May be try TRANSPOSE (either transpose in a sheet or use inner function transpose) some of your tables to have all vertical or all horizontal (function MATCH needs 1D vector as second argument).

As Kaper suggested, array confirmed

=MATCH(1,((TRANSPOSE('ARRAY1&2'!C10:C37)>A2)*(TRANSPOSE('ARRAY1&2'!B10:B37)>B2)*((ARRAY3!I1:AJ1=C2)+(ARRAY3!I1:AJ1=D2))),0)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Thank you everyone for your help. Much appreciated!
I transposed the dataset from ARRAY3 and the problem is solved.