Perhaps try a simpler? non-array alternative at the cost
of using just 2 helper criteria columns in sheet: 13DBC
(it's your preference, of course <g)

and ... some suggested simplifications
for the formulas in cols B, D and F
in sheets SHORT-2 and OVER-2 as well

Sample at: http://www.savefile.com/files/9947056
File: sonar_stockproblem_wksht.xls

In sheet: 13DBC
-----------------------
Insert 2 new columns E & F
Put in E10: =IF(C10="","",ROW())
Copy across to F10, fill down to F60
(or more as desired. Can fill down ahead of expected data)

(Leave the cells above the starting row, i.e. E1:F9 empty)

In sheet: SHORT-2
-------------------------
Put in A10:
=IF(ISERROR(SMALL('13DBC'!E:E,ROWS($A$1:A1))),"",
INDEX('13DBC'!A:A,MATCH(SMALL('13DBC'!E:E,ROWS($A$ 1:A1)),
'13DBC'!E:E,0)))

Put in B10:
=IF(ISNA(MATCH(A10,STOCK!A:A,0)),"",
INDEX(STOCK!B:B,MATCH(A10,STOCK!A:A,0)))

Put in D10:
=IF(ISNA(MATCH($A10,'13DBC'!A:A,0)),"",
INDEX('13DBC'!C:C,MATCH($A10,'13DBC'!A:A,0)))

Put in F10:
=IF(ISNA(MATCH($A10,'13DBC'!A:A,0)),"",
INDEX('13DBC'!AZ:AZ,MATCH($A10,'13DBC'!A:A,0)))
(ensure that col AZ is the results col - it's just a guess here. adapt to
suit.)

Fill down the respective cols

In sheet: OVER-2
-------------------------
Put in A10:
=IF(ISERROR(SMALL('13DBC'!F:F,ROWS($A$1:A1))),"",
INDEX('13DBC'!A:A,MATCH(SMALL('13DBC'!F:F,ROWS($A$ 1:A1)),'13DBC'!F:F,0)))

Put in B10:
=IF(ISNA(MATCH(A10,STOCK!A:A,0)),"",
INDEX(STOCK!B:B,MATCH(A10,STOCK!A:A,0)))

Put in D10:
=IF(ISNA(MATCH($A10,'13DBC'!A:A,0)),"",
INDEX('13DBC'!D:D,MATCH($A10,'13DBC'!A:A,0)))

Put in F10:
=IF(ISNA(MATCH($A10,'13DBC'!A:A,0)),"",
INDEX('13DBC'!AZ:AZ,MATCH($A10,'13DBC'!A:A,0)))
(ensure that col AZ is the results col - it's just a guess here. adapt to
suit.)

Fill down the respective cols
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--