tHIS IS THE FORMULA I AM USING AND AM RECEIVING THE ABOVE ERROR
MESSAGE.
=INDEX('[Goods in.xls]Backups'!$E$2:$E$3000,LARGE((B7='[Goods
in.xls]Backups'!$A$2:$A$3000)*ROW('[Goods
in.xls]Backups'!$A$2:$A$3000),COUNTIF('[Goods
in.xls]Backups'!$A$2:$A$3000,B7)-'[Goods
in.xls]Backups'!$E$2:$E$3000+-1)-1)

Cells E2-E3000 hold the locations i want to bring back and cells
a2:a3000 hold the SKU.
B7 is the SKU on the workbook, what i am trying to do is bring back
loctaions for a paticular SKU where on most occasions hold more than
one location....


Can anyone please advide, i would be happy to send the workbook to
anyone who can help