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($A4 =Backup!$C$2:$C$3000,ROW(Backup!$H$2:$H$3000)),ROW ($1:$1)),1)),"",INDEX(Backup!$H$2:$H$3000,SMALL(IF (Backup!$C$2:$C$3000=$A4,ROW(Backup!$C$2:$C$3000)) ,ROW($1:$1)),1))
Can you please advise