vlookup

[littlelegs]

I have a weekly cash flow statement for 52 weeks to December 2013 in one tab i.e. 52 columns of data. In another tab, I have a 4 week i.e. monthly view of the data. On a separate input tab users are able to select the appropriate week ending date which then automatically feeds through to my 4 week output tab, giving you a "live" monthly view.

I want the 4 week view to change automatically when the user updates the week ending date i.e. to look at another set of four weeks.

I was thinking the best way to do this would be to look up the user input week ending date to return that column of data in my weekly sheet and then to use an offset funtion to return the column to the right of this... and so on.

What is the best way of doing this? I can't get my vlookup to work using dates.

Am I approaching this completely the wrong way? Is there a simpler method?

 

[L. Howard]

Hi littlelegs, welcome to the forum.

If I am reading your post correctly I think you can do what you want by using Indirect(A1) in your vlookup formula as the Lookup_array and the cell (A1) contains the Named Range or perhaps the Named Cell of the week/day you want to view.

I use a similar method on a worksheet that has 44 named ranges, some are 300 rows deep, others 50, 188 rows and so on. Your would all be no larger than seven (seven days in a week).

It would be difficult to try to explain how to do that here.

If you want you can send me an email with example workbook attached and I will give it a go. If successful I will post a link back to this thread with the completed workbook solution.

I am at:

l h kittle @ Comcast . net

Remove the spaces.

Make sure you have no private information in the workbook and include as much detail in plain Englishas to what you want to happen and where you want it to happen.
Perhaps add one or two examples of what the result would look like if all went the way you wanted.

Regards,
Howard