Is this possible? How? 2 sheets/2 variables

[Nadjim]

I have column A with product code numbers on it and column B with price on one sheet 1.

On sheet 2, i have column A with the product codes (not in the same order as sheet 1) and on column B the quantity available in stock.

I would like to evaluate my stock, so i would like for Column C in sheet 2 to go get the price (column B in sheet 1) according to the product code number (column 1). Keep in mind column A in the two sheets are not in the same order.

Thanks so much for your help.