On Sat, 25 Jun 2005 19:44:01 -0700, "Ashish Mathur"
wrote:

Hi,

Array enter this one (Ctrl+Shift+Enter)

IF(ISERROR(INDEX($A$1:$B$7,SMALL(IF($A$1:$A$7=$A$ 10,ROW($A$1:$A$7)),ROW(1:1)),2)),"",INDEX($A$1:$B$ 7,SMALL(IF($A$1:$A$7=$A$10,ROW($A$1:$A$7)),ROW(1:1 )),2))

A1:A7 houses the SKU no and B1:B7 houses the LoC no. A10 houses the SKU
against which you want the value.

Regards,

Ashish Mathur


OK, I see what's happening here. Your formula needs to be copy/dragged down to
obtain the various instances. That was not initially clear to me.
--ron