Excel formula – copy cells from second worksheet

Hi, I hope someone can help. I’ve got a workbook that contains a daily sales log, and the second sheet is a stock list with prices.
In the sales log, Col. A is where the barcode data is entered (we’ve got that bit sorted) and Col. C is where the price comes up (hopefully).
In sheet 2, the barcode data is already entered in col. C, with the prices in Col.B.
What I need to happen is for any given cell in Col A in sheet 1, when a value is entered (barcode data) say in A3, I want it to search the whole of Col.C in sheet 2, then when it finds a match, say on line 17, I need it to copy the contents of B17 to C3 in sheet one.
I think thats as best as I can explain it.
Many thanks
Madison