On 26 Jun 2005 10:07:06 -0700, "gordo" wrote:

My appologies. i have tried the formula below which has some success i
still have a problem when the SKU dosent match it is bringing the next
location down even when this is attached to a different SKU.
=IF(ISERROR(INDEX(Backup!$C$2:$H$3000,SMALL(IF($A 4=Backup!$C$2:$C$3000,ROW(Backup!$H$2:$H$3000)),RO W($1:$1)),1)),"",INDEX(Backup!$H$2:$H$3000,SMALL(I F(Backup!$C$2:$C$3000=$A4,ROW(Backup!$C$2:$C$3000) ),ROW($1:$1)),1))
Can you please advise

I forgot to include in this post, although I mentioned in my first reply in one
of your other threads, that the formula is an *array* formula and must be
entered with <ctrl<shift<enter. Look back at my first response if this is
confusing.


--ron