The first thing that needs to be done with this worksheet is some slightly different formatting. What you are after can be accomplished with some vlookup and month formulas. The issue is your data is not separated into cells. The question is does your worksheet need to stay formatted like this? If it does we can work around it but it will be a lot more formulas to pull it off.