Facing issue formula GOOGLE sheet

[rafiz87]

Please help me what correct formula in google sheet to define the correct result. currently i try to use match but show wrong result.
=ARRAYFORMULA(IF(P3: P = "", "", IF(ISNUMBER(MATCH($W$1 & P3: P & O3:O, $S$1 & K3:K & J3:J, 0)), "Received", "Missing")))

 

[p45cal]

It seems to work all right, so the problem is what is the 'correct' result?
Difficult to know what needs putting right from something which is giving the wrong result.



Probably best to give us some data along with the expected results somewhere and a bit of narrative explaining what it's supposed to be doing.

 

[rafiz87]

It seems to work all right, so the problem is what is the 'correct' result?
Difficult to know what needs putting right from something which is giving the wrong result.

View attachment 89539

Probably best to give us some data along with the expected results somewhere and a bit of narrative explaining what it's supposed to be doing.

i share the picture for your reference. please refer to column X should show correct result.

 

[p45cal]

No I really need a link to a workbook.
A complete guess from your picture:

=ARRAYFORMULA(IF(O3:O<>$W$1,"-", IF(P3:P = "", "", IF(ISNUMBER(MATCH($W$1 & P3:P & O3:O, $S$1 & K3:K & J3:J, 0)), "Received", "Missing"))))