Hello everyone
I hope to find a solution with you... is over my had
I will open a little store in couple of weeks, and the goods are coming bulk on pallets (200 different items on each pallet)
We receive the manifest before, so I have all the EAN code in excel
Also I generated the barcode , qr code and description for new labell (D, E column)
Already installed the barcode scanner that introduce in excel the EAN number
When will come the goods, I wanna take a product from the palet, I scan it with barcode scanner . (if the product is in the manifest , than come back with “true” in column C,same row (this is ok, I have the formula). In that moment automaticly print out the new labell (but corresponding and based on EAN code colomn B ) always the label is in D:E column , same row as the EAN code
Example in the picture:
Scanned code A2
The ean code exist, and is true , but the label for this is D3:E3
This happening because the goods are scanned not in a specific order
Can someone help?
Thank you,
Cristian
I hope to find a solution with you... is over my had
I will open a little store in couple of weeks, and the goods are coming bulk on pallets (200 different items on each pallet)
We receive the manifest before, so I have all the EAN code in excel
Also I generated the barcode , qr code and description for new labell (D, E column)
Already installed the barcode scanner that introduce in excel the EAN number
When will come the goods, I wanna take a product from the palet, I scan it with barcode scanner . (if the product is in the manifest , than come back with “true” in column C,same row (this is ok, I have the formula). In that moment automaticly print out the new labell (but corresponding and based on EAN code colomn B ) always the label is in D:E column , same row as the EAN code
Example in the picture:
Scanned code A2
The ean code exist, and is true , but the label for this is D3:E3
This happening because the goods are scanned not in a specific order
Can someone help?
Thank you,
Cristian
| proba QR 12 febr salvat.xlsx | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | SCAN | EAN | TRUE or FALSE | ||||
| 2 | 123456789 | 12345 | TRUE | Epson EcoTank ET-8550 3-in-1 Tinten-Multifunktionsgerät (Kopie, Scan, Druck, A3, 5 Farben, Fotodruck, Duplex, WiFi, Ethernet, Display, USB 2.0), Tintentank, schwarz | Stockzilla | ||
| 3 | 59439394 | 123456789 | FALSE | Dahle 868 Schneidemaschine (Bis DIN A3, 35 Blatt Schneidleistung) blau | Stockzilla | ||
| 4 | 123456789 | FALSE | Rexel Optimum Auto Feed+ – Distruggidocumenti Automatico, 150 Fogli, Taglio a frammento, Sicurezza P4, per l’Ufficio, Piccolo, Capacità 44 Litri, Cestino Removibile, 2020150X | Stockzilla | |||
| 5 | 1234567892568 | FALSE | Canon PIXMA G7050 MegaTank Tintenstrahldrucker Multifunktionssystem mit nachfüllbaren Tintenbehältern (Drucken, Scannen, Kopieren, Faxen, DIN A4, WLAN, LAN, Duplexdruck, LC-Display), schwarz | Stockzilla | |||
proba | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C2:C5 | C2 | =IF(ISERROR(VLOOKUP(A2,$B$2:$B$1001,1,FALSE)),FALSE,TRUE) |
