Hi,

I've got a stock list with the item, barcode and supplier numbers in, on a
new I now want to make a formula that will once I have scanned in the barcode
it will give me the item name and the supplier number in the two cells next
to the barcode that I've scanned. I want to use this to create a stock return
sheet.