Convert sumproduct formula for use in powerpivot?

I'm looking for a formula for use in powerpivot, that can convert the following formula (I do not wanna use any VBA, only generate a caluculated column in powerpivot, based on a formula)

Please Login or Register  to view this content.

The formula checks for 3 different values, and returns a status code for each. If no match is found it returns "no match".

The formula looks for the criteria (1234 or 1857201 or 1857206) in column2 (item) and writes a status code in column3 (output). At the same time it also checks for simular order numbers (column1). So the same status code is present for all order-number rows. (If a match in column2 / item is found)

Se the excample in regular excell here:

http://www.filedropper.com/book3

I'm playing around with this formula

Please Login or Register  to view this content.

It works for "1234", but if i extend the above formula with IF statements, to combine it with the other 2 criterias (1857201 or 1857206), i just get "NO MATCH"... Maybe the above formula can be used as an inspiration

See below, with the above inserted formula

http://s28.postimg.org/6cn8or9ul/Capture.png