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.

Actually no. It can look like anything, but it seemed to be the best way to explain the problem. My preference would be that the tables are elsewhere (if they're needed at all). Best case, a calculation in a cell and no look up tables. Thanks.