Hi,
I have a table of historical values which I want to return the last 6 months based on the value selected in Cell A7. The data will be dynamically increased each month. I haven't been to find a formula that works without having to explicitly name each row when I do an 'IF' statement. Is there any other way? I also tried to combine vlookup with offset but it did not return the correct value. I want to shorten this formula as I may add more rows in the future. Any help would be appreciated. I am using Excel 2007.
I have attached an example of my problem with the only solution I have come up with so far.
Thanks,
Example.xlsx
Bookmarks