Your workbook needs to included the database of products with the matching barcode number and a description.
On your working worksheet, add a helper column (say column b) next to the column you are scanning into (say, column A). In column B use a lookup formula to join the scanned barcode from column A with the description from the product worksheet.
Good luck with it.
|