Question: how to copy data from one workbook to another in excel using vlookup?
Answer: Open both workbooks (this step isn't mandatory, but makes it easier to create the link)
Create the VLOOKUP formula, and for the table_array argument, select the lookup range in the other workbook. Excel will automatically add the other workbook's name and the worksheet name in the formula.