Hi All,

My issue is that I am trying to do a vlookup against a dataset which is a rolling 24 months. So currently columns H to AE contain product sales data for July 2012(H) to June 2014(AE). I could easily do a vlookup if this data was stand alone but every month the 24 months changes and next month the dataset will be August 2012(H) to July 2014(AE).

I am trying to do a vlookup to return all the months values in the current year, so this will currently be six values (Jan to Jun 2014).

Anyone any ideas of how I will do this? I'm guessing I will need some sort of dynamic vlookup but I can't see now how I will work this out.

Any help is much appreciated, thanks all.