Vlookup won't work for you.
Also an example with sumproduct (see month may and june).
In the past I used indirect to get to month in the formula.
I'm advised not to use it, because it makes the workbook slow, if it gets many calculations.
Do you have questions, on this item, just ask.
Bookmarks