Extracting data

[adnank]

I have posted two times question, but didn't get any answer, probably because I didn't describe my problem in a propper way. I'll try to explain in differently:

I have sheet1 that contains product codes and prices for all products, and sheet2 that contains product codes and product names for products that are currently on stock. I want to extract prices from sheet1 and copy them to appropriate cell in sheet2 for all products that are listed in sheet2 (match criteria are product codes), but I don't know how. Could someone help me, please?

Here is example:
Sheet1
ColA ColB
Row1 985 93,56
Row2 986 22,13
Row3 788 13,20


Sheet2
ColA ColB ColC
Row1 985 Brush ?
Row2 788 Phone ?

In ColC I want to have prices (In this example it should be ColCRow1 93,56 and ColCRow2 13,20).

Thanks