Form in excel for barcode scanning

Hello,

I was wondering if anyone can help me. I need a form in excel, which will have a field where a barcode will be scanned and it will show which product it stands for.

Details:
See the excel attached please. The document contains the table where information about products that need to be shipped is contained:
Brand
Code
Description
Grade
ID - is a combination of brand-code-grade

Barcode - this is not a UPC or EAN, it is an SKU which stands for a package that may contain inside one of the following:
a. 1 piece x 1 ID inside - examples U00HSS51T, U0096M9ON, U00HRH88V
b. multiple ID x 1 pcs each inside - examples U00EMRG9Z, U00OGRMNV, U00ELMVJL
c. one ID x multiple pcs inside - examples U00EMRE29, U00OBKIEB, U00O9BCM5
d. multiple ID x multiple pcs inside - examples U00G8TU2Z, U00NSKVY7

Qty - how many Barcodes we need to ship
Total - Inside * Qty per product ID. In other words, total products ID shipped.
Notes - each case is specific so a note field may be required

The form that I need (probably on another sheet) will contain a field where a specific barcode will be scanned, and based on barcodes from table (column G) it will display (also in a form) information from the table related to barcode:
Product-ID(s), Grade, Brand, Code Description, inside, qty, total, notes (marked red).
Once a product is scanned, I need the indicator to stay there, for easy next barcode scan.

Please let me know if you can handle it. Thanks

Could anyone reply please and let me know your thoughts?