Search code examples
excelnumbersexcel-formulabarcodebarcode-scanner

Barcode number checking with Excel

I have a problem to solve. I scanned 500 barcodes (barcode numbers Excel), which are placed in column A. Now I want to check if the barcode that a given customer returned to me is one of the 500 barcodes scanned before.

Any suggestions?

Thanks for the help.

Munix

Solution

  • If your barcode numbers are in A1:A19, and the barcode number you want to test is in B1, a formula for testing is

    =ISNUMBER(MATCH(B1,$A$1:$A$19,0))

    There are quite a few other options. Copy and paste as needed.