I have a table containg start dates in column a and end dates in column b.
The start date for the second (and subsequent) record is the end date for the
first record plus one day e.g. if the end date was 31/12/2007 then the next
row would show a start date of 01/01/2008.

How can I get a vlookup function to correctly identify the row in which the
target date falls between a start date and end date (both on the same row).

Once the correct row has been selected the vlookup will need to lookup the
contents of a cell to the right of the indexing columns.

I have tried this by only using the end date and find that the function
selects the row before the row containing the relevent start and end dates.

Thanks for any help/advise.