Taryn
New Member
Hi,
I'm not great at INDEX MATCH but think this is what I need, basically I am trying to get the same results that I already have in the yellow highlighted section but instead of having to manually change the formula to update to the next month each time I want it to do this automatically.
I have a different sheet in my actual file that has input information and the month is on there I just forgot to add it in the sample but you can just link to a cell anywhere on this file and I can update it to the correct one.
Help will be greatly appreciated
I'm not great at INDEX MATCH but think this is what I need, basically I am trying to get the same results that I already have in the yellow highlighted section but instead of having to manually change the formula to update to the next month each time I want it to do this automatically.
I have a different sheet in my actual file that has input information and the month is on there I just forgot to add it in the sample but you can just link to a cell anywhere on this file and I can update it to the correct one.
Help will be greatly appreciated