Hi, I was given this formula,

=INDEX('Stock Req 3-8 Digit BarCodes'!$B$1:$X$5,SUMPRODUCT(SMALL(ROW('Stock Req 3-8 Digit BarCodes'!$2:$5)*('Stock Req 3-8 Digit BarCodes'!$W$2:$W$5>0),ROW()-1+COUNTBLANK('Stock Req 3-8 Digit BarCodes'!$W$2:$W$5))),COLUMN())

I need to know what part of this formula makes it impossible to just use this in any cell. For instance, I can use it in A2, but if I use it in say B9 of my worksheet "short", it gives me the #NUM / #REF! error. How should I go about modifying it?

Regards
Antoinette