New Xlookup Function A Vlookup Comparison

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=pURSha68Mjs

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint... • Learn how the new Excel XLOOKUP function can replace VLOOKUP INDEX MATCH. Partial match, reverse order, and horizontal lookup formulas are now possible with this one function. • XLOOKUP can perform both vertical or horizontal lookups to return a value from a matching row or column. The function only requires 3 arguments and separates the lookup and return arranges for lookup formulas that are easier to read and write. • Read the full article and download the Excel file: https://www.excelcampus.com/functions... • Here is the agenda for the video. • 1. Overview of XLOOKUP. How to write the formula and an explanation of all 5 arguments. 0:56 • 2. Horizontal lookups 4:16 • 3. Partial Match with Wildcard Characters 4:56 • 4. Reverse Search Order 6:54 • 5. A brief preview of XMATCH 7:47 • 6. XLOOKUP vs. VLOOKUP 8:12 • 7. XLOOKUP to the Left 10:04 • 8. XLOOKUP Closest/Approximate Match 10:33 • 9. XLOOKUP vs INDEX MATCH 11:30 • 10. Pros or Advantages of XLOOKUP 13:01 • 11. Cons or Drawbacks of XLOOKUP 13:48 • 12. # VALUE! Error with XLOOKUP 14:20 • 13. VLOOKUP Assistant preview 16:02 • 14. Availability Compatibility 18:48 • 15. Questions for you 19:49 • Please leave a comment below and answer either or both of the following questions: • 1. What do you think of XLOOKUP? • 2. What other uses or problems are you wondering if XLOOKUP can solve? • Additional Resources: • To get XLOOKUP you will need to have an Office 365 subscription and be on the Insiders Fast Channel using Excel for Windows or Mac. Here is a link to join the free Office Insiders program. https://insider.office.com/ • Download the Excel file I use in the video: https://www.excelcampus.com/filedownl... • Note: You will need a version of Excel that supports XLOOKUP for the formulas to work. • Download the VLOOKUP Assistant Tool: https://www.excelcampus.com/functions... • Video about VLOOKUP Assistant: • Excel Vlookup Assistant - Watch A Pre... • Thank you! 🙂 • #ExcelCampus #MsExcel • 00:00 Introduction • 00:16 The New XLOOKUP • 04:18 Horizontal Lookup • 04:56 Partial Match with Wildcards • 06:54 Search Order • 08:13 XLOOKUP vs. VLOOKUP • 10:34 Closest Match • 11:31 XLOOKUP vs. INDEX MATCH • 13:02 Pros Cons of XLOOKUP • 18:48 Availability Compatibility

#############################

New on site