Excel Formula - URGENT - TechRepublic
Question
February 11, 2014 at 12:15 PM
samtitus

Excel Formula – URGENT

by samtitus . Updated 12 years, 3 months ago

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 average all the values it finds for that person in January 2014

This discussion is locked

All Comments