Xlookup In Excel: Explained In 3 Minutes
Excel Campus - Jon
@excelcampusAbout
Excel Campus is here to help you learn Excel and save you time with your everyday tasks. My name is Jon Acampora and my goal is to help you improve your Excel skills. This channel contains "how-to" tutorial style videos on a wide range of Excel topics including: formulas, pivot tables, macros, VBA, charts, dashboards, Power Query, Power Pivot, Power BI, and much more. I want to hear from you and learn about what you are struggling with in Excel. Please visit my website and subscribe to my free email newsletter. http://www.excelcampus.com/newsletter/ And don't forget to subscribe to our YouTube channel. Thank you!
Latest Posts
Video Description
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
You May Also Like
Upgrade Your Aerial Footage
AI-recommended products based on this video
DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production
DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production
DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production
SanDisk 64GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXU-064G-GN4IN
SanDisk 128GB Extreme PRO SDXC UHS-I Memory Card - C10, U3, V30, 4K UHD, SD Card - SDSDXXD-128G-GN4IN
SanDisk 4TB Extreme Portable SSD - Up to 1050MB/s, USB-C, USB 3.2 Gen 2, IP65 Water and Dust Resistance, Updated Firmware - External Solid State Drive - SDSSDE61-4T00-G25
DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production
DJI Mic Mini (2 TX + 1 RX), Detail-Rich Audio, Wireless Lavalier Microphone for Camera/Android, 2-Person Vlog, Team Production
SmallRig ZV-E1 Camera Baseplate for Sony ZV-E1, Built-in Cold Shoe Mount and QR Plate (for Arca) Quick Switch Between Tripod and Stabilizer for DJI RS 2 / RSC 2 / RS 3 / RS 3 Pro - 4314
NEEWER a6700 L Plate Compatible with Sony Alpha 6700, Quick Switch Aluminum Extendable Side Plate & Anti Twist Baseplate Compatible with Arca Swiss QR System DJI RS 2 RSC 2 RS 3 Pro Gimbals, CA048
