Spreadsheet: 164560d1340810222-cell-in-1-sheet-to-refer-to-string-in-another-and-use-row-information-to-calc-help-fulldailymold-copy
Sheet:  Core Usage

MOLDING LINE: |  |  |  |  |  | CORE USAGE SHEET |  |  |  |  | DATE
CUSTOMER |  |  |  | CODE | SCRAP REASON |  |  | TOTAL | MOLDING |  | CORE STATUS | COMMENTS
 | CORE | CASTING | TICKET |  |  |  | PCS | CORES | [NAME]
 | NO. | M.O. N.O. | QTY. |  |  |  | SCRAP | POURED | Y | N
 |  | M11111 |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
MOLDING LINE: |  |  |  |  |  | CORE USAGE SHEET |  |  |  |  | DATE
CUSTOMER |  |  |  | CODE | SCRAP REASON |  |  | TOTAL | MOLDING |  | CORE STATUS | COMMENTS
 | CORE | CASTING | TICKET |  |  |  | PCS | CORES | [NAME]
 | NO. | M.O. N.O. | QTY. |  |  |  | SCRAP | POURED | Y | N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N
 |  |  |  | O9 | COUNT DISCREPANCY |  |  |  |  |  | QTY RETURNED
 |  |  |  | O5 | BROKEN SHIPPING |  |  |  |  |  | QTY AT LINE
 |  |  |  | 51 | SCRAPPED FOUNDRY |  |  |  |  |  | ALL CORES USED
 |  |  |  | 31 | OVERRUN |  |  |  |  |  | Y                          N