I have 3 workbook and need to extract data from WkBk 2 &
3 into Workbook 1. I am using the VLookup and was able
to extract the data from workbook into workbook 1 using
this command =VLOOKUP (A4,'D:\SE Excel\[po.xls]Sheet1'!
$A$1:$F$1000,6,0). However, whenever, I make changes to
get the data from the 3rd workbook, I get #ref!. The 3rd
workbook name is purch.xls and the Lookup column is G2
and the lookup range is $C$1:$c$1000,7,0), This formula
was used to extract the data from Workbook 2 into
Workbook 1, which worked fine. The data I am looking to
extract is a date. So, in others words When the
purchase order in Workbook one matches in workbook 3 then
I need to extract date.

Thanks in Advance for Anybody help and as usually needed
this info yesterday.