Need to create multi-criteria lookup without helper column

[gmomo]

Hi folks, thanks for all the awesome tips thus far!

SUMMARY:
I have (1) purchase orders for crayons and (2) a list of several different companies with bagged crayons in varying sized quantities. I'd like to find orders that were made in sequential order that have matching SKU's that are 1-digit apart in incremental order (100,101 but not 101,100) without using a helper column

STEPS TAKEN:
1) The 'Orders' sheet (Column B&C) - contains purchase orders for crayon colors and the Qty. needed
2) All Sku's from the 'Stock' sheet that match the criteria (Color and Qty) are selected from various companies (ex. Shady, Grady, 1-size Betty) and placed (SMALL'd) on the 'Orders' sheet 'Matches area' (Column F to I) as helper columns for step 3.

Working formula in the "MATCHES" section (F4 to I19)
(This formula gets the appropriate SKU from the "stock" sheet and looks for: Matching color, and quantity)
(F4) =IFERROR(INDEX(Stock!$A$4:$A$25,SMALL(IF([@Color]=Stock!$B$4:$B$25,IF([@Qty]>=Stock!$D$4:$D$25,IF([@Qty]<=Stock!$E$4:$E$25,ROW(Stock!$A$4:$A$25)-ROW(Stock!$A$4)+1))),COLUMNS($A4:A4))),"")

3) On the 'Orders' sheet, I then created a '+1 SKU difference' formula (Columns K to N) to search through the Matches (F to I) and only show results for SKU's from the 'Stock' sheet that are 1-digit apart in incremental order.
Working formula for the SKU's that have a 1-digit incremental counterpart
(K4) =IFERROR(SMALL(IF(COUNTIF($F5:$I5,$F4:$I4+1),$F4:$I4),COLUMNS($A4:A4)),"")

PROBLEM:
I'm in need of doing the multi-criteria search for the current row and following row ('Orders' sheet row 4 and row 5) and showing SMALL'd results from left to right revealing all SKU's that have a +1 SKU in the next row within one single formula.

In case it's not clear, I need to somehow get this into one formula using this logic:

Find results from ('Orders' F4-I4)
=IFERROR(INDEX(Stock!$A$4:$A$25,SMALL(IF([@Color]=Stock!$B$4:$B$25,IF([@Qty]>=Stock!$D$4:$D$25,IF([@Qty]<=Stock!$E$4:$E$25,ROW(Stock!$A$4:$A$25)-ROW(Stock!$A$4)+1))),COLUMNS($A4:A4))),"")

and subtract the SKU number from the results of Sku's found as a result of this formula ('Orders' F5-I5)
=IFERROR(INDEX(Stock!$A$4:$A$25,SMALL(IF([@Color]=Stock!$B$4:$B$25,IF([@Qty]>=Stock!$D$4:$D$25,IF([@Qty]<=Stock!$E$4:$E$25,ROW(Stock!$A$4:$A$25)-ROW(Stock!$A$4)+1))),COLUMNS($A5:A5))),"")

and report all SKU's that have a 1-digit higher value in the following row like I did with this formula (K4-H4) =IFERROR(SMALL(IF(COUNTIF($F5:$I5,$F4:$I4+1),$F4:$I4),COLUMNS($A4:A4)),"")

- THE DATA SET -​

Filelink:
https://dl.dropboxusercontent.com/u/2447350/pics/Crayon Demo.xlsx

Note: Correct results are in the 'SKU DIFFERENCE = +1 (Column K through L) area on the 'Orders' sheet. It is currently searching through results from the Matches area. I will have thousands of these rows and want to eliminate the mess by creating a single formula.


Sheet name "Orders"

PURCHASE ORDERS			MATCHES					SKU DIFFERENCE = +1
(A) Order #	(B) Color	(C) Qty			(F) SKU	(G) SKU2	(H) SKU3	(I) SKU4		(K) +1 SKU DIFF	(L) +1 SKU DIFF2
1	Grey	96			101	400	601			400
2	Grey	81			100	401	601
3	Black	90			300	701
4	Blue	80			200	801				200
5	Blue	105			201	501
6	Black	92			300	701
7	Blue	116			201	501
8	Black	120			301	703
9	Black	55			702	802
10	Black	95			300	701
11	Grey	80			100	401	601	800		401	601
12	Grey	60			402	602	800			800
13	Blue	15			500	801				500
14	Blue	125			501
15	Black	51			702	802				702
16	Black	121			301	703

<tbody>
</tbody>

Sheet name "Stock"

STOCK
SKU#	Color Group	Package	Qty Min	Qty Max
100	Grey	Shady Grey Small	80	85
101	Grey	Shady Grey Large	86	110
200	Blue	Shady Blue Small	80	89
201	Blue	Shady Blue Medium	90	120
202	Blue	Shady Blue Large	121	115
300	Black	Shady Black Small	90	110
301	Black	Shady Black Large	111	125
400	Grey	Grady Grey Large	90	110
401	Grey	Grady Grey Med	75	89
402	Grey	Grady Grey Small	55	74
500	Blue	Grady Blue Ex Small	15	25
501	Blue	Grady Blue Extra Large	100	150
600	Grey	Grady Grey Special Large	100	119
601	Grey	Grady Grey Special Medium	80	99
602	Grey	Grady Grey Special Small	50	79
700	Black	Grady Black Large	100	110
701	Black	Grady Black Medium	61	99
702	Black	Grady Black Small	50	60
703	Black	Grady Black Extra Large	111	130
800	Grey	Betty 1-size	10	80
801	Blue	Betty 1-size	10	80
802	Black	Betty 1-size	10	80

<tbody>
</tbody>

Thanks in advance!

 

[gmomo]

Due to my poor explanation, I'm assuming no one could figure out what I was looking for but, unfortunately, I don't know how to erase/edit the original.

I found a work around, but it involved searching for ROWs in sequential order instead of the SKU's which proved to be much more complex.