You may also check the solution from the thread below:
You would just replace the selector and the formula with the relevant one, like =VLOOKUP(A2,‘[MasterSheet.xlsx]Sheet1’!1:1048576,2,FALSE)
You may also check the solution from the thread below:
You would just replace the selector and the formula with the relevant one, like =VLOOKUP(A2,‘[MasterSheet.xlsx]Sheet1’!1:1048576,2,FALSE)