Vlookup with Named ranges

Leith, I appreciate your help. Thank you. However, I have run into a problem running the code. I got a Run-time error '1004':Application-defined or object-defined error and the following part of the code is highlited in yellow:

Set rFoundIt = .Find(What:=.Range("Date1"), _
                       After:=.Cells(1, 1), _
                       LookAt:=xlWhole, _
                       LookIn:=xlValues, _
                       SearchOrder:=xlByRows, _
                       SearchDirection:=xlNext, _
                       MatchCase:=False)

Could this error be because, I do not have a named range of "Date1" in the temp file?
What I figured is that the macro would look at the value of that named range in the destination file and go and find that value in the temp file.
Also, the dates in the temp files are formulas, does this matter?