What the function - XLOOKUP for Excel in simple words

Chandoo • May 28, 2020

Chandoo

About

👋 Hello. I make you AWESOME at your work 😎 I make videos on Excel, Power BI & Data Analytics so that you can be awesome at your work. ✅ Excel ~ Power BI ~ SQL ~ Python ~ Interview Prep ✅ New Video Every Week ~ Subscribe 💻📗 My courses Advanced Excel 👉 https://chandoo.org/wp/excel-school-program/ Advanced Power BI 👉 https://chandoo.org/wp/power-bi-course/ Everything 👉 https://chandoo.org/mdac ~ KNOW 😀 About me: https://chandoo.org/wp/about/ What I'm doing now: https://chandoo.org/wp/now/ Stuff I use: https://chandoo.org/wp/about/what-we-use/ FOLLOW 🚶‍♀️🚶‍♂️ 🌐 Website - https://chandoo.org/wp/ 📃 FREE Data tips newsletter - https://chandoo.org/wp/subscribe/ 📚 Courses - https://chandoo.org/wp/training-programs/ 📷 Instagram - https://www.instagram.com/chandoo.xlsx/ 💥తెలుగు Telugu Channel - https://www.youtube.com/channel/UCuaf89M0Lt5pmXzaUssXHvw/

Latest Posts

Test Your SQL Skills With These Real Interview Questions!

Chandoo

The Ultimate Excel Dashboard: Visualize Data Like a Pro

Chandoo

The surprising trick to fix Table Spill Formula Errors!

Chandoo

Dynamic Moving Average with Excel OFFSET

Chandoo

Video Description

Welcome to what the function - a new series of no nonsense guides on Excel functions. In the first instalment, let's look at XLOOKUP, the VLOOKUP killer. Use XLOOKUP to find matching data from your tables or ranges. The syntax for XLOOKUP is, =XLOOKUP(what you want to lookup, lookup range, result range, optional if error value) XLOOKUP will return EXACT match by default. For more information on XLOOKUP, please see this page - https://chandoo.org/wp/xlookup-examples/ #xlookup #WhatIsXlookup #VlookupAlternative

What the function - XLOOKUP for Excel in simple words

Chandoo

About

Latest Posts

Test Your SQL Skills With These Real Interview Questions!

The Ultimate Excel Dashboard: Visualize Data Like a Pro

The surprising trick to fix Table Spill Formula Errors!

Dynamic Moving Average with Excel OFFSET

Video Description

You May Also Like

Upgrade Your Gaming Setup Now

Dell 15.6&quot; FHD Touchscreen Student and Business Laptop – AMD Ryzen 7 7730U, Radeon Graphics, 16GB DDR4 RAM, 512GB SSD, USB-C, HDMI, SD Card Reader, Wi-Fi 5, Copilot Ready, Windows 11 Pro

ACEMAGIC 2025 Laptop AMD Ryzen 7 5825U (8C/16T), 15.6“FHD Display,16GB RAM 512GB NVMe SSD, WiFi 6, Numeric Keyboard, Type_C, 54.72Wh Battery | Windows 11 Pro Laptop Computer for Work &amp; Play

BOSGAME P3 Lite Mini PC, AMD Ryzen 7 6800H Mini Computer (8C/16T, up to 4.7GHz), 24GB DDR4 1TB M.2 NVMe SSD, Triple Display Desktop Gaming PC, Pre-in Win 11 Pro, Dual LAN, WiFi 6E, BT 5.2

BOSGAME M4 Mini PC Oculink, AMD Ryzen 7 8745HS 32GB DDR5 RAM 1TB PCIe4.0 SSD,Radeon 780M Quad Displays,USB4,Dual LAN 2.5GbE LAN Micro Desktop Computer

GIGABYTE - AORUS Elite 16 Gaming Laptop - 165Hz 2560x1600 WQXGA - NVIDIA GeForce RTX 5070 - Intel Core Ultra 9 275HX - 1TB SSD with 32GB DDR5 RAM - Windows 11 Home AD (AORUS Elite 16 BWHC3USC64SH)

HP Victus 15.6&quot; 144Hz FHD Gaming Laptop, Intel i5-12450H, 32GB RAM, 1TB PCIe SSD, NVIDIA GeForce RTX 3050, Backlit Keyboard, HD Webcam, Win 11, Blue, 256GB Docking Station Set

Acer Swift X 14&quot; FHD Laptop, AMD Ryzen 7 5825U, NVIDIA GeForce RTX 3050Ti, 16GB RAM, 512GB SSD, Windows 11 Home

Asus ROG Strix 1000W Gold Aura Edition (Fully Modular Power Supply, 80+ Gold Certified, ATX 3.0, Cybenetics Lambda A+ Certification, PCIe Gen 5.0 Ready, Axial-tech Fan, Aura Sync, 10-Year Warranty)

Corsair RM1000e Fully Modular Low-Noise ATX Power Supply - Dual EPS12V Connectors - 105°C-Rated Capacitors - 80 Plus Gold Efficiency - Modern Standby Support - Black

Corsair RM1200x Shift Fully Modular ATX Power Supply - Modular Side Interface - ATX 3.1 &amp; PCIe 5.1 Compliant - Zero RPM Fan Mode - 105°C-Rated Capacitors - 80 Plus Gold Efficiency - Black, 1200W

Corsair RM1200e (2023) Fully Modular Low-Noise ATX Power Supply with 12V-2x6 Cable – ATX 3.1 &amp; PCIe 5.1 Compliant, Cybenetics Platinum Efficiency, 105°C-Rated Capacitors, Modern Standby Mode – Black

Corsair HX1200i (2025) Fully Modular Ultra-Low Noise ATX Power Supply with 12V-2x6 Cable – ATX 3.1 &amp; PCIe 5.1 Compliant, Cybenetics Platinum Efficiency, Fluid Dynamic Bearing Fan – Black

Corsair Vengeance LPX 32GB (2 X 16GB) DDR4 3200 (PC4-25600) C16 1.35V Desktop Memory - Black

Samsung 990 EVO Plus - 4TB PCIe Gen4. X4, Gen5. X2 NVMe 2.0 - M.2 Internal SSD, Speed Up to 7,250 MBs, Upgrade Storage for PC-Laptops, HMB Technology and Intelligent Turbowrite (MZ-V9S4T0B/AM)

SAMSUNG 870 EVO SATA SSD 500GB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E500B/AM [Canada Version]

SAMSUNG 870 EVO SATA III SSD 4TB 2.5” Internal Solid State Drive, Upgrade PC or Laptop Memory and Storage for IT Pros, Creators, Everyday Users, MZ-77E4T0B/AM [Canada Version]

SAMSUNG EVO Select Micro SD-Memory-Card + Adapter, 128GB microSDXC 160MB/s Full HD &amp; 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME128SA/AM) [Canada Version]

Western Digital 2TB WD Blue SA510 SATA Internal Solid State Drive SSD - SATA III 6 Gb/s, 2.5&quot;/7mm, Up to 560 MB/s - WDS200T3B0A

CORSAIR iCUE Link XD5 RGB Elite LCD Pump-Reservoir Unit - D5 PWM Pump - 480x480 IPS LCD Screen - 22 Addressable RGB LEDs - 440ml Nylon Reservoir - White

CORSAIR iCUE Link XC7 RGB Elite CPU Water Block - Transparent Flow Chamber - 24 RGB LEDs - Fits Intel® LGA 1700, AMD® AM5 and Older - White

CORSAIR Hydro X Series iCUE Link XH405i Custom Cooling Kit – Hardline Water Cooling Loop – XC7 Elite CPU Water Block – XD5 Elite D5 Pump Res – XR5 360mm Radiator – 3X QX120 RGB Fans

Razer BlackShark V2 X Gaming Headset: 50mm Drivers - Cardioid Mic - Memory Foam Cushion - Lightweight- Comfortable, Noise Isolating Earcups - for PC, PS4, PS5, Switch - 3.5mm Audio Jack - Black ECOLOGO

Logitech G435 Lightspeed and Bluetooth Wireless Gaming Headset - Lightweight Over-Ear Headphones, Built-in mics, 18h Battery, Compatible with Dolby Atmos, PC, Mobile - Black

Logitech M185 Wireless Mouse, 2.4GHz with USB Mini Receiver, 12-Month Battery Life, 1000 DPI Optical Tracking, Ambidextrous, Compatible with PC, Mac, Laptop - Black

Logitech G305 LIGHTSPEED Wireless Gaming Mouse, Hero 12K Sensor, 12,000 DPI, Lightweight, 6 Programmable Buttons, 250h Battery Life, On-Board Memory, PC/Mac - Black

Logitech K400 Plus Wireless Touch TV Keyboard With Easy Media Control and Built-in Touchpad, HTPC Keyboard for PC-connected TV, Windows, Android, Chrome OS, Laptop, Tablet - Black

Loading...

Dell 15.6" FHD Touchscreen Student and Business Laptop – AMD Ryzen 7 7730U, Radeon Graphics, 16GB DDR4 RAM, 512GB SSD, USB-C, HDMI, SD Card Reader, Wi-Fi 5, Copilot Ready, Windows 11 Pro

ACEMAGIC 2025 Laptop AMD Ryzen 7 5825U (8C/16T), 15.6“FHD Display,16GB RAM 512GB NVMe SSD, WiFi 6, Numeric Keyboard, Type_C, 54.72Wh Battery | Windows 11 Pro Laptop Computer for Work & Play

HP Victus 15.6" 144Hz FHD Gaming Laptop, Intel i5-12450H, 32GB RAM, 1TB PCIe SSD, NVIDIA GeForce RTX 3050, Backlit Keyboard, HD Webcam, Win 11, Blue, 256GB Docking Station Set

Acer Swift X 14" FHD Laptop, AMD Ryzen 7 5825U, NVIDIA GeForce RTX 3050Ti, 16GB RAM, 512GB SSD, Windows 11 Home

Corsair RM1200x Shift Fully Modular ATX Power Supply - Modular Side Interface - ATX 3.1 & PCIe 5.1 Compliant - Zero RPM Fan Mode - 105°C-Rated Capacitors - 80 Plus Gold Efficiency - Black, 1200W

Corsair RM1200e (2023) Fully Modular Low-Noise ATX Power Supply with 12V-2x6 Cable – ATX 3.1 & PCIe 5.1 Compliant, Cybenetics Platinum Efficiency, 105°C-Rated Capacitors, Modern Standby Mode – Black

Corsair HX1200i (2025) Fully Modular Ultra-Low Noise ATX Power Supply with 12V-2x6 Cable – ATX 3.1 & PCIe 5.1 Compliant, Cybenetics Platinum Efficiency, Fluid Dynamic Bearing Fan – Black

SAMSUNG EVO Select Micro SD-Memory-Card + Adapter, 128GB microSDXC 160MB/s Full HD & 4K UHD, UHS-I, U3, A2, V30, for Android Smartphones, Tablets, Nintendo-Switch (MB-ME128SA/AM) [Canada Version]

Western Digital 2TB WD Blue SA510 SATA Internal Solid State Drive SSD - SATA III 6 Gb/s, 2.5"/7mm, Up to 560 MB/s - WDS200T3B0A