Remove values from array based on helper columns

[tminhv]

=FILTER('INVENTORY-COMMIT'!A:A,((LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!N1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!O1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!P1)*NOT('INVENTORY-COMMIT'!A:A=N2:N3)))

I want remove values from array based on helper columns when filled in. It works when NOT formula is referring only to a single cell, I can do multiple of those and it works fine. This isn't efficient as I would have to individually list from n2 to p500. I'm assuming that it's throwing a N/A because it's attempting to filter based off of the ENTIRE referenced range instead, but then it should do the same when the single cell reference is empty, right?

1. refer
	A												M	N	O	P
1	item_number												Type	p-
2	P-10C12												Remove
3	P-10C12BS
4	P-10C14
REORDER

Cell Formulas
Range	Formula
A2:A304	A2	=UNIQUE(FILTER('INVENTORY-COMMIT'!A:A,((LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!N1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!O1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!P1)*NOT('INVENTORY-COMMIT'!A:A=N2))))
Dynamic array formulas.

1. refer
	A												M	N	O	P
1	item_number												Type	p-
2	#N/A												Remove
3
4
5
6
REORDER

Cell Formulas
Range	Formula
A2	A2	=UNIQUE(FILTER('INVENTORY-COMMIT'!A:A,((LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!N1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!O1)+(LEFT('INVENTORY-COMMIT'!A:A,2)=REORDER!P1)*NOT('INVENTORY-COMMIT'!A:A=N2:N3))))

 

[Anonymous1378]

Try replacing your NOT(...) with ISNA(XMATCH('INVENTORY-COMMIT'!A:A,N2:N100))?
Similarly, ISNUMBER(XMATCH(LEFT('INVENTORY-COMMIT'!A:A,2),REORDER!N1:P1)) should replace the other part.

 

[tminhv]

Try replacing your NOT(...) with ISNA(XMATCH('INVENTORY-COMMIT'!A:A,N2:N100))?
Similarly, ISNUMBER(XMATCH(LEFT('INVENTORY-COMMIT'!A:A,2),REORDER!N1:P1)) should replace the other part.

That's perfect, thank you!