Scanning barcodes not bringing up corresponding data in the table

Sorry can you attach a sample sheet showing what you are trying to do, that screenshot is blocked.

Are you trying to get the barcode details from a lookuptable?

Thats still blocked, can you click go advanced and attach the file that way. I work for an FS company, everything is blocked!!!! :o)

=VLOOKUP(E3,Table1,2,0)

What you were doing was correct, in a way, it was an array formula, ready your book 1st though :o) As you hadnt committed it properly it was only checking the top line. Good way to think about formulas the way you did though, keep that in the back of your mind, that is the way they work better, so a common Qty x Price = Total for 10 rows, would be ={((a1:10)*(b1:10))} Excel only reads that as one formula, so using that will make your workbook open and recalc faster, but read your book first.

Sorry if ive confused you, you just seem to have a good inituative way with arrays.