VBA Code For Vlookup Function with Table_Array from Another Workbook

Hi,

I will like to write a VBA code consisting of VLookup function. The problem I face now is that the source of data which i will be pulling the information from is in sheet2 of another workbook and I have tried but failed to come out with a code that work. The code I have so far is as followed. Can someone guide me on how to complete the code to make it work?

Say the path of the source file is this, C:\Users\Ken\Documents\Book 1.xlsx

Sub Test()

Dim j As Long

With Range("F2:F" & Range("A" & Rows.Count).End(3)(1).Row)
    .Formula = "=VLOOKUP(A2, [Book 1]Sheet2!$A$1:$D$" & Sheets("Sheet2").Range("A" & Rows.Count).End(3)(1).Row & ",3,FALSE)"
        
End With


End Sub