Something I just noticed while working through some of the reports...while the values always start in column G, they aren't necessarily the first month of the fiscal year. For example, one report might span from G to V and include all 16 periods but another report might not have data for all periods so it'll run from G to N where the values in G are period 3, H are from period 5, I are from period 6, and so on. So, going back to the formula that I originally used (because it seems to do what I need it to)...how might I add an additional piece to that to have it look at both the periods AND the values in column A? I was trying to get an INDEX MATCH MATCH formula to work but couldn't exactly figure out how to make it operate. I'll keep experimenting but maybe someone has a suggestion on how to accomplish this? Thanks!
Bookmarks