Quick question about using a barcode scanner with excel

  • Thread starter Thread starter Johnsey
  • Start date Start date
J

Johnsey

I was wondering if you imported data from another program into exce
could you then use a barcode scanner to highlight the item related t
the barcode and perhaps add the date the item was scanne
 
You would use the barcode scanner to enter the barcode in the cell. Then in
an adjacent cell you could use vloopup to go against a master list of
barcodes and return related data

assume the first barcode would go in cell A2 and the imported data is on
Sheet2!A1:F200

in B2 of the barcode sheet you could put in a formula

=if(A2="","",Vlookup(A2,Sheet2!$A$1:$F$200,4,False))

when the barcode is entered in the cell, this would retrieve the data in
column D (the 4 as a 3rd argument to Vlookup) for the row in Sheet2 with the
matching barcode.
 
Back
Top