View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcp201 mcp201 is offline
external usenet poster
 
Posts: 12
Default Indirect VLookup

Would anyone be able to help me in the following??

I need to create a formula using indirect Vlookups to shift a data range
based on a month period.

For example: the current month being March 2008.
using a 12 month of sum of April 2007 to March 2008 - once it becomes April,
I will need it shift the range from May 2007 to April 2008.