Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|