USING INDEX AND RECIEVING #VALUE ERROR MESSAGE

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

Hi!

My best guess is that you're looking for the last instance of a SKU:

Array entered (add the appropriate file and sheet names)

=INDEX(E2:E3000,LARGE((A2:A3000=B7)*(ROW(1:2999)),1))

Biff

"gordo" <gordon.brown24@btinternet.com> wrote in message
news:1121007133.346461.20680@g14g2000cwa.googlegroups.com...
> 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
>