I need to use a simple If function formula. The difficulty is the test argument.

Example: Column B = dates in this column could be any month and day in years 2007 through 2012, formated as 06/10/2007, 09/03/2008.
Column F = amount such as 563.50, 315.95, etc.

Starting with column H through M, the header of the columns with be the years, H=2007, I=2008, etc.



For column H, row 10, which is for year 2007, I would like to test B10 if it is year 2007 and if yes, put the amount found in cell F10 in H10. In I10, I would like to test B10 if it is year 2008 and if yes, put the amount in cell B10 in I10. Do this for the remainder of the cells on row 10 for columns J through M, years 2009-2012 respectively. The amount in B10 will go in only one of the years from 2007 - 2012.

Thanks