I need data from one spreadsheet to flood into another one. I'm pretty familiar with the V and H lookup, and I can't get it to work with this data.

The spreadsheet with the data - Attached

3-11-2013 10-07-14 AM.png

To another cell on another sheet.

What I need it to do..

I need it to look at the date and if it matches the row that I'm moving it to, then I need it to pull the line that says Nom. Here is an issue and why the HLOOKUP isn't working.. the box that says Nom, Conf, Schd, Alloc, Schd-Alloc is a "merged" cell. And I can't get the IF function to look at the date and only pull it if the dates match.