Excel 2007 : Matching cells across different worksheets

Hello, I am still having trouble with my monster excel workbook,

Can anybody please tell me if it is possible to do the following:

If in sheet 1 I have a list of products linked to different characteristics in the same row, such as price:

Product 1, style 2, price 1.3, collection ABC etc...(through 94,000 rows of product!)

and in sheet 2 I have some of the same products, but maybe only 5,000 of the 94,000 above, and with different characteristics:

Product 1, north region, winter season....etc,

Is it possible to apply the price from sheet one to the correct row of the corresponding product in sheet 2?

In other words match a criteria across two sheets (product code) and add a corresponding data cell from one sheet to another?

Hope I explained it okay, and as ever thank you for your help.

Thank you JB,

I'm sorry to trouble you further but could you show me that in the attached example. It would be to get the "current price" from sheet 1 into the corresponding product row of sheet 2.

I'm not sure that I exactly understood the formula so it would be really helpful to see it in action.

OK, Great, I have got that to work with the VLOOKUP function, but can I now add a twist?

Can I make the VLOOKUP match 2 values on sheet 1, with the corresponding 2 values on sheet 2 to return a third value.

Its the same as the previous example but instead of just looking up the product code in column A, it also needs the country code from column B.

I have attached an excel template that contains what I am talking about. See that product W15004 sells in UK and Germany, so would need to pick up the correct price for each location.

Is that possible?

Thanks, do you have any idea why I get a pop up window when I try to apply this formula to the cell? I have attached a picture of what happens whenever I paste the formula. Confused...