I need a formula to do the following
look up a name in column A1 on sheet1
then look up that name on sheet2 in column A1:A6
when it finds that name it need to look in column B to find a date, if that date matches January 2014 it has to look up the value in column c and add all the values it finds for that person in January 2014