We are doing a vlookup for a date cell in both workbook which is in column D
this is the formula
=VLOOKUP(B10,'C:\Documents and Settings\Administrator\My
Documents\[calling_.XLS]Customers'!$A$4:$I$58,4,FALSE)
but we are getting a #REF!
both are date fields also it is in row 30 column d?