How to Use Excel XLOOKUP and XMATCH Functions

preview_player
Показать описание
In this Microsoft Excel 2021 training tutorial video, learn how to use the XLOOKUP and XMATCH functions in Excel. Learn how to look up values from a table or range with more flexibility than VLOOKUP with this short tutorial video!

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
  1. Simon Sez IT
  2. excel tips and tricks
  3. Excel 2021
  4. Excel 365
  5. microsoft excel
  6. excel tutorial
Рекомендации по теме
How to Use 0:13:34

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

XLOOKUP in Excel 0:16:40

XLOOKUP in Excel Tutorial

How to use 0:03:41

How to use the XLOOKUP function in Excel

Xlookup In Excel: 0:03:33

Xlookup In Excel: Explained In 3 Minutes

How to use 0:00:54

How to use the XLOOKUP function in Microsoft Excel

The Ultimate XLOOKUP 0:11:03

The Ultimate XLOOKUP Tutorial (The Best Excel Formula)

Discover What XLOOKUP 0:06:59

Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)

How to use 0:17:15

How to use the XLOOKUP Function in Microsoft Excel - Beginners Tutorial

Advanced Xlookup Function 0:00:42

Advanced Xlookup Function in MS Excel|itskills.p

How to Use 0:13:39

How to Use XLOOKUP in Microsoft Excel

Using Excel's XLOOKUP 0:11:16

Using Excel's XLOOKUP Function

XLOOKUP Function in 0:00:53

XLOOKUP Function in Excel

XLOOKUP in Excel 0:18:47

XLOOKUP in Excel | Excel Tutorials for Beginners

What is Xlookup 0:06:27

What is Xlookup In Excel? | Xlookup Tutorial | How To Use Xlookup In Excel | Excel | Simplilearn

How to Use 0:10:36

How to Use Excel XLOOKUP and XMATCH Functions

Excel XLOOKUP Function 0:20:48

Excel XLOOKUP Function Definitive Guide - Replaces VLOOKUP, INDEX&MATCH & HLOOKUP

How to Use 0:12:55

How to Use the XLOOKUP Function in Microsoft Excel 2021/365

Excel XLOOKUP Function 0:25:02

Excel XLOOKUP Function – Comprehensive Lessons – 27 Examples - Excel Magic Trick 1600

Excel Two-Way XLOOKUP 0:04:04

Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial

XLOOKUP Function | 0:01:54

XLOOKUP Function | Excel One Minute Functions Explained

Functia XLOOKUP in 0:05:57

Functia XLOOKUP in Excel - uita de VLOOKUP

How to use 0:09:36

How to use XLOOKUP to Create Dependent Drop-Down Lists in Microsoft Excel

XLOOKUP Add-in for 0:01:16

XLOOKUP Add-in for Excel 2013, 2016 and 2019

Excel LOOKUP Function 0:11:49

Excel LOOKUP Function Only PROS Use (simple to complex examples)

Комментарии
Автор

🔥Check out our FREE 300+ hour training course playlist here ➡


SimonSezIT
Автор

Extremely clear and precise; very helpful.

emet
Автор

this is good, however, in the 2nd example with google doc in the "utility" category. the formula returned the correct value b/c the category was "productivity". if you had changed the category to "utility", it would have returned the correct value w/o doing the (-1, look up from bottom to top).

donavanthomas
Автор

Thank you very much for the explanation, very well explained and useful...

maxdeniel
Автор

what is we have more than 2 Google Docs?

ahmadullahazizi
Автор

Use xlookup with multiple criteria.. use &

bobbychan
Автор

The most efficient way to do a two-column needed match is to concatenate the look up value and the look up array: Xlookup(B5&B6,

RipRoarLB
Автор

If I want to lookup for Google Docs which is represented twice and I want to pick up both revenue ($17, 990.00 & $50, 000.00) instead of only one, how do I apply this function.

graceisraa