Here is the vlookup example you can use in one of the workbooks and refer to the other workbook. Here i am referring cells A5 to B70 in Sheet1 of Dept.xlsx workbook from other workbook-
"=vlookup(A1,'C:\Department\[Dept.xlsx]Sheet1'!$A$5:$B$70,1,FALSE)"