Quick question about using a barcode scanner with excel

[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

 

[Tom Ogilvy]

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.