Using XLOOKUP Across Multiple Workbooks
Excel's XLOOKUP function provides a superior alternative to other lookup functions in Excel, including VLOOKUP and HLOOKUP. XLOOKUP is powerful, adaptable, and easier to use than the alternatives. In this short tip, you will learn how you can use XLOOKUP to find information in a different workbook.