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$50),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


--
sonar
------------------------------------------------------------------------
sonar's Profile: http://www.excelforum.com/member.php...fo&userid=8424
View this thread: http://www.excelforum.com/showthread...hreadid=399608