Copying cells based on date.

Hi Team,

I'm looking for some help in copying some data from one sheet to another based on the condition of dates - I've attached an example worksheet


Basically what I'm looking to do is take the date value in Sheet2 - B3, search through Sheet1 - Column B until there is a match. When there is a match copy the values on the same line in Columns E&F into the relevant cells in Sheet 2.

Basically copy the Prices in USD and GBP from sheet 1 to sheet 2 where the dates line up!

Sorry if my explanation is either long-winded or just rubbish!!

Thanks in advance,


- Jon