Date and Vlookup Help

[paulpitchford]

Hi,

I need to do a date lookup. I have this in my worksheet:

A, B
25/05/2011, Week 1
01/06/2011, Week 2
08/06/2011, Week 3
etc...

I have a cell that is set to =TODAY() in C30.

I want C31 to show which week it is based on todays date. Therefore if when the sheet is loaded, it is 28/05/2011 C31 will show Week 1. And if it was 30/05/2011 it would still show Week 1.

Can someone help me with this as I keep getting #N/A in C31.

This is my current forumla in C31: =VLOOKUP(C30,A2:B28,2,TRUE)

Many Thanks,

Paul.

 

[VoG]

You are getting #N/A because your list of dates and weeks starts later than today. If you add a week 0 date of 18/5/2011 at the top of your lookup table it will work.

 

[paulpitchford]

You are getting #N/A because your list of dates and weeks starts later than today. If you add a week 0 date of 18/5/2011 at the top of your lookup table it will work.

That's exactly it. Thank you so much.

Paul.