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" wrote in message
ups.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