XLOOKUP - the BEST Excel Function - FULL tutorial

  Рет қаралды 3,862

ExceLearner

ExceLearner

3 ай бұрын

XLOOKUP full tutorial. Best Excel function -XLOOKUP. Learn how to use the XLOOKUP function in Excel with practical examples. No more need to use VLOOKUP, HLOOKUP and INDEX MATCH functions. All arguments of the XLOOKUP function are explained, and also powerful tips are included in this tutorial.
⬇️ Download FREE Excel Formulas Practice file from below page:
xllearner.com/
👇 Join thousands of students who already learned Excel:
courses.xllearner.com/p/excel...
For the BEST price, in Excel Essentials course for beginners you will find everything to get you from absolute beginner to confident Excel user in less than a WEEK!!!
🎓Join today! 🎓
courses.xllearner.com/p/excel...
#excel

Пікірлер: 9
@Profia22
@Profia22 Ай бұрын
Thank you for the video. Xlookup is very powerful function especially when used with tables. May be you could dedicate a video on this topic.
@CideeTV
@CideeTV 2 ай бұрын
Easy and clear to understand
@AtulDwivedi-sq6ch
@AtulDwivedi-sq6ch 3 ай бұрын
love you bro your tutorial are absolutely blast.
@annemarieplamondon5694
@annemarieplamondon5694 2 ай бұрын
Great tutorials… We want more😊
@luigibru8677
@luigibru8677 3 ай бұрын
+0... Masterclass!
@gopichandguttikonda2181
@gopichandguttikonda2181 2 ай бұрын
Great video🎉. But i have one doubt, in last example, if colums are not side by side, then how to get multiple values.
@ExceLearner
@ExceLearner 2 ай бұрын
as third argument enter this: CHOOSE({1,2},A:A,D:D) where A:A and D:D are two columns not side by side. hope this helps 🙂
@ksumar
@ksumar 2 ай бұрын
The last tip, is there actually a formula on the surname at "Tucker" (Last name), or is Excel spilling the cells in column C
@ExceLearner
@ExceLearner 2 ай бұрын
Yes, There is just one formula in cell B2 and it is spilling result to C2
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 68 М.
The Ultimate XLOOKUP Tutorial (The Best Excel Formula)
11:03
Kenji Explains
Рет қаралды 135 М.
小女孩把路人当成离世的妈妈,太感人了.#short #angel #clown
00:53
Is it Cake or Fake ? 🍰
00:53
A4
Рет қаралды 19 МЛН
VLOOKUP vs XLOOKUP - Detailed Comparison with Examples
20:30
TrumpExcel
Рет қаралды 4,7 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 437 М.
5 Excel Hacks Exposed #shorts
5:18
Mike Song: Digital Transformation Expert
Рет қаралды 9 М.
10 Advanced XLOOKUP Tips & Tricks
21:04
Chandoo
Рет қаралды 28 М.
Master Excel Formulas Fast: 5-Minute Tutorial
6:04
ExceLearner
Рет қаралды 1,1 М.
Using Excel's XLOOKUP Function
11:16
Technology for Teachers and Students
Рет қаралды 91 М.
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,2 МЛН
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)
13:34
Leila Gharani
Рет қаралды 3,5 МЛН
Excel How To use Wildcard with XLOOKUP and FILTER
4:11
Excel University
Рет қаралды 7 М.
小女孩把路人当成离世的妈妈,太感人了.#short #angel #clown
00:53