Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Xlookup In Excel: Explained In 3 Minutes. That video is uploaded by Excel Campus - Jon at 2019-09-10T09:34:39-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [txK0C6SkaMg]
| Name | Xlookup In Excel: Explained In 3 Minutes |
| Video Uploader | Video From Excel Campus - Jon |
| Upload Date | This Video Uploaded At 10-09-2019 16:34:39 |
| Video Discription | Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video, I give a brief overview of the new XLOOKUP function in Excel, an alternative to VLOOKUP or INDEX MATCH. Here are some of the major features of XLOOKUP that I share in the video: 1. Only 3 Required Arguments 2. Exact Match by Default 3. Separate Lookup & Return Ranges 4. Vertical OR Horizontal Lookup 5. Partial Match with Wildcards 6. Reverse Search Order 7. Cause of # VALUE! Error 8. Availability & Compatibility The XLOOKUP function searches for the lookup value in a column/row and returns a value from an adjacent row/column where the match is found. It has options for exact match, closest match, and partial match with wildcard characters. It can also search in reverse order. Additional Resources: Full In-Depth Tutorial on XLOOKUP: https://youtu.be/pURSha68Mjs Blog post on XLOOKUP: https://www.excelcampus.com/functions/xlookup-explained/ VLOOKUP Tutorial: https://youtu.be/d3BYVQ6xIE4 VLOOKUP Assistant Preview: https://youtu.be/g2_Yu_VRQ9E Please leave a comment below with any questions or suggestions. Thank you! 🙂 #ExcelCampus #MsExcel 00:00 Introduction 00:50 XLOOKUP 01:58 Search Order txK0C6SkaMg |
| Category | Education |
| Tags | excel | excel campus | xlookup | xlookup in excel | vlookup in excel | xlookup vs vlookup | xlookup vs index match | excel lookup value | excel lookup wildcard text | excel lookup partial match | excel lookup reverse order | excel xlookup reverse order | xlookup value error | #value error xlookup | xlookup tutorial | xlookup explained | xlookup for beginners | xlookup everything you need to know |
