I have two worksheets. Worksheet 1 is called FX and worksheet 2 is called Converted Price.

FX has a list of dates in column A1:A1000 in the following format dd/mm/yyyy i.e 01/01/2011 and exchange rates in Column B1:B1000 i.e 0.87

Converted Price Column A1:A1000 contains dates in the same format as FX (dd/mm/yyyy i.e 01/01/2011) and Column B1:1000 has an amount i.e $19,944.30.

I need a formula in Converted Price C1:C1000 that will search and match the same date in Converted Price A1:A1000 and FX A1:A1000, If matched then multiply the number in Converted Price B1:B1000 by the exchange rate number in FX Column B1:B1000 and display answer in C1:C1000

Is this possible? If so what is the formula?

If this is not possible is there another way of achieving the result I need?

Many thank in advance