Help with Formula for barcode scanning

[ronplaja]

I have our pricebook for our plumbing company in excel with the barcode in column A and the prices for each piece of material in column E. I want to have a blank sheet 1 open with the pricebook on sheet 2. When a tech scans a barcode for a material they will be using on the job I want it to populate in column A and reference the price in column E from sheet 2 in the same row. So if they scan the material that happens to be in cell A32 in sheet 2 I want it to populate in cell A1 of sheet 1 and have cell B1 populate the price from cell E32 in sheet 2. Thank you so much if someone reads this and takes the time to answer. Hopefully it makes sense! -Ron