Hi, welcome to the board.
It sounds like there are two parts to your problem.
Part 1) Scanning in the barcode
Part 2) Looking up the data for the barcode number.
I can't help you with (1).
But you can use LOOKUP formulas (for example VLOOKUP) to do part (2), or alternatively a combination of INDEX and MATCH.