I have a spreadsheet the holds the Date, week #, Day,,Month,Year. in separate columns for this year and the next 10. This I've been using to find a date and give me the corresponding week number. Now I want to turn it around slightly and search for a week number and have both start and end date of the week returned.

The spreadsheet is laid out as:

Date Week Day Month Year
01/01/2000 1 1 1 2000
02/01/2000 1 2 1 2000
03/01/2000 1 3 1 2000
04/01/2000 1 4 1 2000
05/01/2000 1 5 1 2000
06/01/2000 1 6 1 2000
07/01/2000 1 7 1 2000
08/01/2000 2 8 1 2000
09/01/2000 2 9 1 2000
10/01/2000 2 10 1 2000

etc.
etc.

I use a Vlookup(date,whole range of info,2,FALSE) to return the week number but as the week number is the second column in the data range I can't do it in reverse, Vlookup(Week number,whole range of info,-1,FALSE)!!
How can I find the first date for week 1 and the last date.

Thanks

Dean

http://www.dkso.co.uk/

http://homepage.ntlworld.com/dkso