Help with find and replace formula or vlookup?

Can someone please tell me how to run a Vlookup that will find a date and if that date falls in between certain dates, return text based on where the date falls?

more specific...

cell M6 on PMS sheet runs a VLookup to cell K2 on PPS sheet and sees the date 1/18/2010.

the following table on sheet SD in in cells C3:D14
10/15/2006:12/20/2006 Pre T
10/15/2007:12/20/2007 Pre T
10/15/2008:12/12/2008 Pre T
10/15/2009:12/12/2009 Pre T
12/21/2006:1/16/2007 T to F
12/21/2007:1/18/2008 T to F
12/21/2008:1/20/2009 T to F
12/21/2009:1/15/2010 T to F
1/17/2007:4/9/4007 F to H
1/19/2008:4/9/2008 F to H
1/21/2009:4/9/2009 F to H
1/16/2010:4/9/2010 F to H

since 1/18/2010 falls between 1/16/2010:4/9/2010, i need to have F to H return in cell M6 on the PMS sheet

You would best be served by posting a sample of worksheet "SD", it isn't clear from your post how it is structured.

If it is as it appears, then it might just be causing unnecessary problems.