Formula between two worksheets [if not possible please provide alternate solution]

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

Put this in C1:

Formula:

=IFERROR(VLOOKUP(A1,FX!A:B,2,0)*B1,"")

then copy down.

Hope this helps.

Pete

It works! Thanks so much, you have just saved a life!

I have another question it would be great if you could answer?

I have a sheet called 2010, column A1 has months i.e A1 is Jan, A2 Feb and so on. I have another sheet called BL2012. Column L has dates listed in the following format 01/01/2010 etc and Column U has volume i.e 1000.

I was wondering is their a formula that will search all days in a month e.g. in BL2012 that are **/01/2010 and take the corresponding volume for that date in column U, add them together and populate the answer into sheet 2010 cell b2 for Jan volume?

I.e
Column L Column U
15/01/2010 100
13/01/2010 250
11/01/2010 1700

Formula searches all dates in January adds the volumes together and populates the answer in sheet 2010 for the month of january. In this case sheet 2010 b2 would equal 2050.

Many thanks again for your help before, I hope this one is easy for you like last time

Cheers