VLOOKUP slightly different text

[csch123]

Hello,

I currently run reports out of a database, and the system has it's own way of naming the data. For instance, the month of December 2012 may read December, 2012 12:00. In addition, the report provides a number of different data points that coincide with that date range.

On another sheet, I have a summary sheet that I want to pull this data over based off of a VLOOKUP. The summary sheet would just read December 2012, but not have the 12:00. I would want the VLOOKUP to read from that specific cell and search for the closest comparison on my database output. If it finds a match, then I want it to return the data from the other column that coincides. Any suggestions?

I basically want the VLOOKUP to look in cell A1 of the summary sheet (December 2012), match it to a date value that is similar on the output sheet (December, 2012 12:00). If it is a match, then throw the value in column 2 of the output sheet into a different cell on the summary sheet.

[Pepe Le Mokko]

Could you please post a small sample sheet?