How to pull a column of data into an Excel report from another spreadsheet using VLOOKUP and then XLOOKUP functions. Extract data from one workbook to another. You'll learn how to apply the VLOOKUP and XLOOKUP functions to your data extraction tasks. Whether you're a beginner or an advanced Excel user, this video will help you save time and reduce errors in your work. Let's compare VLOOKUP and XLOOKUP.