Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP)
Вставка
- Опубліковано 7 лип 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Discover the power of Excel's XLOOKUP function in this beginner-friendly tutorial. XLOOKUP simplifies data searching, making it an essential tool for efficient Excel use. Get ready to elevate your Excel skills with this easy-to-understand guide.
⬇️ DOWNLOAD the workbook here: pages.xelplus.com/xlookup-exp...
No more VLOOKUP?! The NEW Excel XLOOKUP Function is here to stay!
Discover how XLOOKUP can solve your Excel lookup problems. Remember all those times your VLOOKUP wasn't working? You will have a better chance of getting your lookup formula correct on the first try.
🔍 What You'll Learn:
▪️ XLOOKUP Basics: Understand the fundamentals of XLOOKUP including its primary arguments and how it outperforms traditional lookup functions.
▪️ Real-World Application: See how XLOOKUP can resolve common workplace challenges like identifying employee divisions and calculating bonuses.
▪️ Advanced Usage: Learn how to use XLOOKUP for both vertical and horizontal lookups, and for finding the last match in a dataset.
▪️ Versatility: Discover XLOOKUP's ability to work with unsorted data and its default exact match search, making it more flexible and powerful than VLOOKUP and HLOOKUP.
AVAILABILITY: XLOOKUP is available to Excel for Office 365 and Office 2021 users. If you'd like to learn about the other brand new Excel functions like FILTER, UNIQUE & SORT check out the complete course: www.xelplus.com/course/excel-...
00:00 What is Excel XLOOKUP
00:55 XLOOKUP Basic Function
02:50 Get Last Match with XLOOKUP Search Mode
03:54 Get Next Smaller Match with XLOOKUP Match Mode
05:51 Why Excel XLOOKUP is Better than VLOOKUP
What is XLOOKUP?
If you need to lookup a value on another Excel sheet or table, you can use the XLOOKUP function. Here are some of its features:
- XLOOKUP can lookup values to the left OR right-hand side of the lookup range.
- XLOOKUP looks for an exact match by default (you can change it if you like)
- Use XLOOKUP to look for the next smallest value or the next largest value (approximate or close match)
- XLOOKUP can do vertical AND horizontal lookups
- XLOOKUP can find the first match or the last match (reverse lookup)
And guess what? XLOOKUP can also be combined with another XLOOKUP to lookup values inside a matrix - which means XLOOKUP can replace INDEX & MATCH formulas too!
➡️ Join this channel to get access to perks: / @leilagharani
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel #XLOOKUP
![ОРБАН приехал к ПУТИНУ и "отчитался" о поездке в Киев 😁 [Пародия]](http://i.ytimg.com/vi/_0ukDovOWq8/mqdefault.jpg)
Grab the file I used in the video from here 👉 pages.xelplus.com/xlookup-explained-file
Check it out XLOOKUP with even more examples: ua-cam.com/video/4c0CLUER6nw/v-deo.html
But Leila, I have try it is not working at my end
"No.
序号" "Apply Date
申请日期" "Value Date of Payment
支付日期" "Invoice or Check No.
发票号 或 支票号" "Payment Amount
支付金额" "Currency
币种" "Original Amount
原币金额" "Original Currency
币种" "Payee
付款对象" "Payment Purpose
支付事项"
1 25/11/19 28/11/19 Nil 2,225.00 USD 2,225.00 USD Nil Gizem MERAL #NAME?
2 25/11/19 28/11/19 Nil 2,988.00 USD 2,988.00 USD Fuat ER Contractor Fees
3 25/11/19 28/11/19 Nil 850.00 SGD 850.00 SGD Sherry Anne Nazareno Contractor Fees
4 25/11/19 28/11/19 Nil 72,000.00 INR 72,000.00 INR Chloe Maria Fernandes Contractor Fees
5 25/11/19 28/11/19 POLYNDT /10-19/110 7,800.95 MYR 7,800.95 MYR Sikom Supplies Sdn Bhd Contractor Fees -Muhammad Adhwa Afiq Bin Sallehuddin
6 25/11/19 25/11/19 9160003711 1,500.00 USD 1,500.00 USD Seward & Kissel LLP Professional Services Rendered
in my excel I try to look for xlookup it does not have it
this format can work in ms office which year?
That means we won't need iferror function
You know you’re a nerd when you watch a video like this on Saturday sitting in your recliner because you think it’s “fun”.
Lol me right now
Totally agree!! And excited to use it at work on Monday lol
Omg today is Saturday and I am watching this for fun. Well, I guess that proves it I am a nerd lol
Right there with you except it's Sunday when I am watching this video
Exactly me right now lol
God bless you Leila and your family, wish you best of success, thank you! I just got into Excel and the functions seem very hard to understand for someone new to this. When I see people do calculations and I see terms and numbers, that can be very overwhelming, you made it easy to remember and understand.
Keep up the good work :)
I just had to come back here to thank you again for this excellent tutorial. I am using Xlookup more and more. I haven’t used V look up for about four months now. I think it can replace index and match as well. I used it recently nested in an IF statement. I was basically using it to produce 3 different outcomes. The IF variable drove which area to point the Xlookup. There were three different Xlookup‘s within my IF statement. And that is why I think it could replace index and match. THANK YOU!!!!
Yesterday while searching for something in excel I saw your videos. Im really lucky for came across your videos. Now I am one of your subscriber. I shared your videos to my friends also. Thanks for all your effort. Hereafter you are my mentor, guide, advisor for all my excel related doubts.
The Xlookup is a genius override on Vlookup. Put a bar on that function already :)
Thanks Leila!
XLOOKUP will definitely change the usability of MS Excel and standard user can facilitate more practice in various way. Especially if it comes with FILTER function ❤️ I can not wait them!
It definitely will!
Lol I thought Ms meant Miss Excel and that that was her nickname or online persona. ,🤐
Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple and no wonder draw tourists come to Holly Khilasa temple to vist at all,as long as modification of all kinds of hotels,motel facilities of all classes,definitely make big money globally at all,particularly from Europe,North America,Japan,Korea@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become flourish in different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century,if not famous geologist,cosmology and archeologist not interested to visit the greatest nation of India.Last century 80-2 thousand ,movies as Fly and Lara Croft: Tomb Raider still have good memory in 21th@@@@@Korean language:Un yon ha sai your?Man lai saw pan gar voo your?Man lai saw pan kar saw me dar?Chung pak kar see mei dar?Chung lung keith128@gmai.com,keith Au lee me dar?Chung lung gee kam Hon kwok gor lau pair all koo lee me dar.Chat pak kar see lee me dar.All saw all sai more dee lee kai your?Coffer shop kee saw,ching koo low man lai your?Koo tsang air kee saw yuen wah low pair soy your.Tick yuen guar your.Tea me it sai soy your.Lai,li,tea me it sai soy your,kee luck gee man,hing kar lai soy your.Un yon he kee sai your.Un yon he car sai your,Kam shan ha me dar.Koo mei voo your.Un yon.Japan language:Oh hei your!Oh hei your gor ja yee mas?Kron lee gee wah?Ma dar?Kin kit das ah ma lee ma shan?Door more.Dore more ah lee gar door.Sai your lai lai@@@@@
Is it possible in xlookup that if it doesnt found any value it doesnt change the current value?
Thanks Leila for introducing this fantastic feature and thanks to the Excel team engineers. You've made the life easier for us!
Great! I finally got a chance to look at this function as it is now available for all MS 365 users. The officially released XLOOKUP function is even a bit better than we can see in Leila's great video. It contains another parameter [if_not_found] which is not mandatory and might be good for dealing with #N/A errors without any other IFERROR or IFNA functions. Another fine feature I noticed is that I can use lookup_value as array too and it works. I still need more practice for all of it to sink in but I can see it is a very promising function. Maybe one thing I would like to see in some future versions of this function, would be a parameter for k-th match.
I needed this 3 jobs ago. Wow! Love it.
Wow very helpful every time I use vlookup I have to move columns then only I should use now it's over with Vlookup thanks a lot
lol
Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple and no wonder draw tourists come to Holly Khilasa temple to vist at all,as long as modification of all kinds of hotels,motel facilities of all classes,definitely make big money globally at all,particularly from Europe,North America,Japan,Korea@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become flourish in different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century,if not famous geologist,cosmology and archeologist not interested to visit the greatest nation of India.Last century 80-2 thousand ,movies as Fly and Lara Croft: Tomb Raider still have good memory in 21th@@@@@Korean language:Un yon ha sai your?Man lai saw pan gar voo your?Man lai saw pan kar saw me dar?Chung pak kar see mei dar?Chung lung keith128@gmai.com,keith Au lee me dar?Chung lung gee kam Hon kwok gor lau pair all koo lee me dar.Chat pak kar see lee me dar.All saw all sai more dee lee kai your?Coffer shop kee saw,ching koo low man lai your?Koo tsang air kee saw yuen wah low pair soy your.Tick yuen guar your.Tea me it sai soy your.Lai,li,tea me it sai soy your,kee luck gee man,hing kar lai soy your.Un yon he kee sai your.Un yon he car sai your,Kam shan ha me dar.Koo mei voo your.Un yon.Japan language:Oh hei your!Oh hei your gor ja yee mas?Kron lee gee wah?Ma dar?Kin kit das ah ma lee ma shan?Door more.Dore more ah lee gar door.Sai your lai lai@@@@@Esponel language:Oh lai?Amigo?Boy low lee dar?Boy low dar das?Boy low not chas?Come mao star?Come mao star who's stead?Wee bee and.Mucho mei bien.And kee where tao must dar lee?And kee where tao yuen dar lee?So low as door mei lan tao.Come mao sai ah fair?Ah fair soy bean tao?Ah fair fee law?Ah fair kar law?Mucho guesto.En can car dar corn low fat tao?Mucho muy bien.Adidos,Us dar pronto.Us dar manana,Us dar llegeuo,Que tengus un van dia@@@Saibor amei,Voy ageagu lai luz,Como han passado los anos,lai gata boho lai lluvia,Eu sei que voy tu amar,Usted abuso,Pero mei acurado de ti===All Spanish love song,melody and very touching down,still listening it everyday@@@@@
I am amazed by the quality of your tutorials. Perfect speed, perfect visualization, perfect explaination in line with the visualization and - perfect look ;-) This looks like a team efford with love to details. It really leaves a professional impression and is easy to watch, even for non native speakers. Thanks for your videos.
Thank you very much!
Omg...I have been using Excel for 21 years...my job is literally to sit and build Excel reports all day long...you have just changed my life. Subscribed!
Then you'll definitely love the new functions. Great to have you here Adam!
Have been through so many similar channels.
Yours stands out.
Good Luck!
The greater things of xlookup are
1. It doesn't care where your lookup array is located (no more match index formula)
2. Can match logically, mind blowing
It's definitely an enhanced version of Vlookup
Thanks bringing things into limelight
Great video about the new X function, Teammate!!!
Thank you teammate Mike. I love your XL version!
I'm also subbed to your channel. 👍
‘The meaning of life is to find your gift. The purpose of life is to give it away.’ Thank you so much for sharing this Leila, you are a star.
You are so welcome Martin!
So facinated with your creative tips and tricks videos and started thinking should I quit my job and start working with your organization [And that is TRUE]. Really loved it !!
That's what I always wanted to do. Thanks a ton !! ☺️
Superb!
Yeah@@@Thanks so much,my dearest friend,learn a lot from your channel.Most of them playing tricks on viewer,excopt my dearest Indian truly friend in the world---Overjoy,These dreams,West End girl,Hands to heaven,how can i call,all favorite song of mine."Nepalese languageTai chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar dar @t mei link it.Anyway,i love language,and i speak a little bit of Japanese,Korean,Thai,France,Espanol,German besides English at all just to spare time at home in my desktop to kill time and use it wisely,I also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing ,language of universal from other galaxy as India=== Holly Khilasa Temple,really Wonder of the World crafted from bed rock as hard as granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil temple---Chariot temple and no wonder draw tourists come to Holly Khilasa temple to vist at all,as long as modification of all kinds of hotels,motel facilities of all classes,definitely make big money globally at all,particularly from Europe,North America,Japan,Korea@@@@@Bless all India friends ,all Buddha philosophy import from India from 3-4th,Dharma to Shaolin temple in the period of China North and South dynasty,then experience later on almost 50 years of internal power struggle of civil war and northern troops invasion from Huns of different tribes up North,after that Buddhism flourished in Tong dynasty in 6-9th A,D and then become flourish in different division as in Tibet,Japan,Korea and South East Asia.India,the greatest nation of the world,so humble,so clever and intelligent to create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all ,God from Orion Belt,Masterpiece,Specialist and Genius in 21th century,if not famous geologist,cosmology and archeologist not interested to visit the greatest nation of India.Last century 80-2 thousand ,movies as Fly and Lara Croft: Tomb Raider still have good memory in 21th@@@@@Korean language:Un yon ha sai your?Man lai saw pan gar voo your?Man lai saw pan kar saw me dar?Chung pak kar see mei dar?Chung lung keith128@gmai.com,keith Au lee me dar?Chung lung gee kam Hon kwok gor lau pair all koo lee me dar.Chat pak kar see lee me dar.All saw all sai more dee lee kai your?Coffer shop kee saw,ching koo low man lai your?Koo tsang air kee saw yuen wah low pair soy your.Tick yuen guar your.Tea me it sai soy your.Lai,li,tea me it sai soy your,kee luck gee man,hing kar lai soy your.Un yon he kee sai your.Un yon he car sai your,Kam shan ha me dar.Koo mei voo your.Un yon.Japan language:Oh hei your!Oh hei your gor ja yee mas?Kron lee gee wah?Ma dar?Kin kit das ah ma lee ma shan?Door more.Dore more ah lee gar door.Sai your lai lai@@@@@Esponel language:Oh lai?Amigo?Boy low lee dar?Boy low dar das?Boy low not chas?Come mao star?Come mao star who's stead?Wee bee and.Mucho mei bien.And kee where tao must dar lee?And kee where tao yuen dar lee?So low as door mei lan tao.Come mao sai ah fair?Ah fair soy bean tao?Ah fair fee law?Ah fair kar law?Mucho guesto.En can car dar corn low fat tao?Mucho muy bien.Adidos,Us dar pronto.Us dar manana,Us dar llegeuo,Que tengus un van dia@@@Saibor amei,Voy ageagu lai luz,Como han passado los anos,lai gata boho lai lluvia,Eu sei que voy tu amar,Usted abuso,Pero mei acurado de ti===All Spanish love song,melody and very touching down,still listening it everyday@@@@@
The concept is very similiar to Index and match function. I enjoy it.
Yeah@@@Thanks so much,my dearest friend,learn a lot from your
channel.Most of them playing tricks on viewer,excopt my dearest Indian
truly friend in the world---Overjoy,These dreams,West End girl,Hands to
heaven,how can i call,all favorite song of mine."Nepalese languageTai
chi,Nam ma stair?More sum kar lap char?More sum ram bo char?Ram bo shan
gor shan chok char.All lee all lee Nepalese kar ha chen chi.Bolly judy
ho?Judy wo ho car jan lee,kar num bus lai,ah lai got @t kai your?Kai
your kee kai your?Cho chow,but,rody?Ture look lung lung char?True look
can/t they chew?Dollar bo lai got lai so may ho.Gee tao?Miss dar
lee?More chen chi.Chen chi chok true.Pair lee but tao lai.Hindi,Hindu
language:Kee sai ho?Tai cho!Tao mei dai car tao bo ho who's who?Tao mei
lee judy cai see dee?Up lai judy ma du sai peek su.Moon cha tao lee,tao
lee,Hindi,Hindu art dei hei.Mei ah bee Hindi,Hindo art dee hei.Mei India
kam kee hei ,gar gee @t bag dai bar kar kar hei,easy art dee @t ho men
sai ha @t hei bo ho got me hei ,kam beer jar dar "Ban lee"b @t hei bo ho
dash bar lish hei!Chat dar sure lure kee mut.Can/t lai lee kai ho?Can/t
lai nei he?Can/t lai nei he kai ah mei tao mei kee lai dar @t bag dai
bar kar kar @t ho ma sai he hei.Mei ah bee Hindi,Hindo she lai dar
hung,Indian,Parkstain dos banana jar dar hung.More jar dar Hindi,Hindo
see corner door ,Hindi,Hindo bo lai wah lai Shing bar kar see hung @t
hei bo ho man gar hei,easy kar gee kee,can/t lai hung kar.A bee duck
can/t lai nei he tea,bar hei bo ho man gar hei,kar gee kee,can/t lai
hung kar.Sub goods key hei?Goods special hei.Ah kar peek gee mut kar
low,doom gee sai got lai jar they ho got lai.Dawh wah sai call low?Dawh
wah sai bun kar low.Kit see gor dawh wah sai call lai bun lai.Judy dean
kit dean kar kee hei?Judy kit dean kit dar jar kee ho?Gar mei it dar jar
lai du ,So lai ha tai alarm kar lai ha tar.Eight lai jar dar kam ho dar
hei,kar jar kee saw jar hung,bo ho tek kee hung.Ah cha, hei hip cha
hei.Eight lai ah shan nei he tea.Eight lai ah cha nei he @t mei link
it.Mei ban @t kar lee @t ah luck @t lai hip see dai mei link it.Doom ah
chat in shan ho,Ju bee mut sai gur mut dee ho.Kee lee ho?Sai dee all dee
hei?but chat hei?But joe kar hei?Kam gar gar they ho?Kam mush kee hei
kee lee?Ah shan hei?Bo ho man gar hei,easy single hei.Mei sooner hei who
bar chat dawh wah sai call lai hei,easy daeh wah sai call lai but lai
but dar hei.Mei sooner hei,who bar chat "Ban lee"lick kar lai ha @t ho
ma sai he hei.Mei jar lai ha hung,bo ho tek kee hung.Mei soon lai jar
dar @t mei link it.Anyway,i love language,and i speak a little bit of
Japanese,Korean,Thai,France,Espanol,German besides English at all just
to spare time at home in my desktop to kill time and use it wisely,I
also learn ancient Egyptian,Mayan,Aztec,Inca languages,all amazing
,language of universal from other galaxy as India=== Holly Khilasa
Temple,really Wonder of the World crafted from bed rock as hard as
granite,hardest point is 8 over 10 or up.Also Sun Temple,Vendor Coil
temple---Chariot temple and no wonder draw tourists come to Holly
Khilasa temple to vist at all,as long as modification of all kinds of
hotels,motel facilities of all classes,definitely make big money
globally at all,particularly from Europe,North
America,Japan,Korea@@@@@Bless all India friends ,all Buddha philosophy
import from India from 3-4th,Dharma to Shaolin temple in the period of
China North and South dynasty,then experience later on almost 50 years
of internal power struggle of civil war and northern troops invasion
from Huns of different tribes up North,after that Buddhism flourished in
Tong dynasty in 6-9th A,D and then become flourish in different
division as in Tibet,Japan,Korea and South East Asia.India,the greatest
nation of the world,so humble,so clever and intelligent to
create"1.2.3.4.5.6.7.8.9.10"-Arabic number,still world wide usage at all
,God from Orion Belt,Masterpiece,Specialist and Genius in 21th
century,if not famous geologist,cosmology and archeologist not
interested to visit the greatest nation of India.Last century 80-2
thousand ,movies as Fly and Lara Croft: Tomb Raider still have good
memory in 21th@@@@@
Wow, I have been stressing myself out trying to do this and for some reason other videos just kept getting me that VALUE error. This video somehow turned something on in my brain and now I have mastered Xlookup!
Many thanks for going over this new function Leila 😃 Looking forward to your future videos where you delve deeper into it’s uses in various situations.
My pleasure Roberto. I'm very excited about it so I'll definitely expand on this.
XLOOKUP is quite easy to use, thanks Leila
Love watching your videos!
I never knew you could hold down shift and drag cells between other cells until I saw you do it in this video! Always thought you had to insert a row first!
It's the little tricks like this that save so much time!
Thank you again Leila 😊
I am trying to drag and drop between cells but cannot (it tries to overwrite). How does it work?
@@rgsoni Press "Shift" button when you drag and drop!
@@manojkt190 Thank you. I did figure out by trail and error after I posted the question. Appreciate your reply.
@@manojkt190 How do you insert columns with drag and drop + Shift? it looks like it always inserts rows.
I've seen you use this a couple of times now and I do like the ease of use. It is one of those functions that will be extensively used. Thanks for the great presentation.
I think so too. Once it's available for everyone on Office 365 it will be one of the most used functions.
Madam, thank you so much. Your communication is just outstanding.
When is the funeral for VLOOKUP? I would like to attend.
Vlookup, Hlookup, Mach, Index RIP
and HLOOKUP
Bunch of ungrateful corporate minions ready to jump the boat the minute something better come around and forget all the times when vlookup saved you from your misery and desperation. V is for victory!
well... I think VLOOKUP will be around for quite a while. XLOOKUP is one of the cool functions/features in modern Excel. But we all know, most users are not aware of most of the cool stuff in Excel. Excel Table was introduced in Excel 2007. Yes, that's a decade ago... but the fact is MANY people has no idea what an Excel Table is as of today. Power Query is another example....
But don't take me wrong. I think the XLOOKUP is super COOL! :)
@@AdamicWay Haha, it sure did save me a LOT of times. No X-Factor though. I'm jumping ship man!
Thanks very much. I hope Microsoft update this function to all office
Hi Leila, Your videos are awesome. Thank you for your teachings!
This is absolutely brilliant! Thank you so much for posting.
Very nice. Perfect for everyone who never got into the Index & Match functionality.
Index and match are just 🤯🤯🤯
Index/Match is super easy.
1st arg, array that holds the answer and related columns
2nd arg, match function (lookup value, array that holds the answer, false for exact match).
The match pulls the row number to reference.
3rd arg, column # within 1st arg array where you will find the answer.
@@melsheanno index and match is super easy.
Reginald Petalcorin with practice. I recently learned excel and haven’t practiced it so I need some time before finding it easy.
Index match is easy. But it isn't any easier than xlookup.
Shortcut of index match. Thank you for tutorial.
Yeah, an easier alternative :)
@@LeilaGharani is it? you only showed values pulls, you did not do pulls on text data, or any other formats. if you are really claiming this is a shortcut for index match, then do a pull based on General Ledger activity for the Balance Sheet balances so that they tie to financial statements. If it will work, then you can say that it is indeed a shortcut.
@@ISqueezeMyTomatoes It is a shortcut, or rather it is a short cut in the English language meaning of the word. I work in IT and I use Excel when I need to obtain accurate information fast! As much as I love the INDEX and MATCH combo, XLOOKUP will save me time and, I strongly believe it will help my colleagues who do not use Excel as often but they too need accurate information, fast. They're Excel training was based on likes of VLOOKUP and HLOOKUP from years ago. Leila taught me the benefits of INDEX and MATCH, but my colleagues stubbornly stick to VLOOKUP because that's what they were taught and are too afraid of change given the importance of the work we do. I cannot see how my colleagues will not see the benefits of XLOOKUP. And, I cannot wait to use it when it becomes available to me.
I agree!
@@robpickles3736 well, that explains it. if you work in IT then you definitely will be using it as a shortcut, oh, my bad, as a "short cut". you mentioned IT, networking? analytics? security? MIS/DBA? if you mentioned index/match, something tells me you work with data, then you better stick to vlookup, it will not make much of a difference for you. However, the XLOOKUP function might save time for you if you use a lot of arrays, but will it save time to other advanced users that relate on dynamic accurate financial data and complex financial analysis? and yes, I absolutely agree with your point, XLOOKUP will definitely change people lives. Question is, will it be capable to replace Index/Match? BTW, i do not work in IT, i work with IT tools.
I've seen a couple of other videos about xlookup but yours is the best so far. Keep it up!
Thanks for the kind feedback Bobby.
Muchas Gracias, has hecho mi vida mas facil con este video, thank you you have made mi life easier with this video, truly appreciated
Thank you so much. I will no longer use =Index(match) :)
Still have to use it for a while as long as its not availiable to all users ;)
RIP VLOOKUP
1979 - 2019
just try it and really usefull...this lookup from right to left really help me alot.thx
This is so cool. Been struggling with COUNTIF and COUNTSIF fx. This will make my life easier.
WoW!♥️♥️♥️💖💖💖,no counting of cells,RIP VLookup
What is more beautiful - this new XLOOKUP or Leila? Xlookup is awesome but Leila is unbeatable ;)
download tinder asap and find yourself a lady
I have been watching your videos for a few years now, and I am always learning something new. Thank you :)
Backward Vlookup with ZtoA , I love it. Thanks for sharing
What is the use of explaining this function as it still is not available? Will it ever become available?
a good alternative of INDEX+MATCH combo
but, does XLOOKUP has the same problem of huge RAM usage as other LOOKUP family functions?
vlookup algorythm changed in 2018 to increase speed of linear searches.
This reminded me one of your old tutorial where you nested "VLookup" and "Choose" in order to look from right to left. Thank you for this video about XLookup.
Yeah, these tricks are not needed anymore :)
Game changer!
Your videos have me the epiphany that my Excel knowledge is outdated.
Very humbling.
so...how does this stack up against Index/Match? that's all i ever use, haven't used vlookups in a long time.
"Note: November 25, 2019: XLOOKUP is currently a beta feature, and only available to a portion of Office Insiders at this time. We'll continue to optimize it over the next several months. When XLOOKUP is ready, we'll release it to all Office Insiders, and Office 365 subscribers."
Thank you, short n sweet, up to the point
I thoroughly enjoy your videos! You are a very good teacher!
"If you're excited about this, hit that thumbs up!"
*ROBOT VOICE* "Yes, I am excited"
I'm glad to hear that :)
so if someone else comes into the file and re-sorts the division table its still gonna screw up xlookups
I searched some pages for this new function and found that we can sort arrays. Hope someone can confirm this
Awesome! I am so used to VLookup, but this XLookup is a must for me.
Leila you are absolutely amazing for this. I hope your blessings multiply 👌
I’m sorry but index/match killed vlookup years ago
TryvReanimation Jutshu...than kill it again
Offset/match killed index/match shortly thereafter
Double kill for Vlookup/Hlookup
But I always use vlookup
VISHAL BHATI stahp
I'm only learning to so I can say " The only time I look up for my X is on Excel " :)
😂
@@LeilaGharani Please help.. Is there any function in excel to find the outstanding of a loan on a future date.. If you enter a particular date, the program should show the outstanding on that particular date. Please help..
@@leedreamz Try PPMT and IPMT functions
@@satyanarayanyadaw2447 thank you.. will try and update..
Wonderful! So clear when you do your videos.
you explained it very well... thank you
The larger the salary, the larger the bonus... i know it's a toy dataset, but man... those managers are really setting things up for themselves, aren't they?
Funny how that works...lol
This is something i have been pissed about for years. It is like that for the whole world. Shitty.
Sounds like the name of a shady website.
Xlookup - spread your sheets like you never did before
XXX LOOKUP
Thank you! Had difficulty getting this function to work before watching your video. This helped a ton!
Glad it helped!
I love your videos! Definitely my go to channel whenever I encounter excel needed help. Thank you for coming up with such great content! 😍
I'm happy to hear this. It's great to have you here.
Correction : Kim West doesn't have a job!
At first I thought it would be some kind of porn ad
Someone's mind is going too far
That one is not human being, some thing different I think
This is a game changer. Thank you!
i love it you made simple and clear thank you Leila
Brilliant as usual and as stated below, better than Index/Match when you have to find the last match in a list.
Brilliant, this saves all the prepping of data to put it into the right place and order to work
No doubt it is one the most useful technique for data management while doing accounting tasks. I personally used while sorting salaries and other informations. Thanks for sharing
Thanks for sharing!
Your videos are absolutely brilliant. Straight to the point and exactly what you’re looking for. Thank you so much
Glad you like them!
This is quite amazing. Thanks for these tutorials.
Brilliant as always. So easy to follow and always informative
Never seen anyone use this helpful feature. Thank you Leila
Lovely.. That's so crisp & clear... U r awesome 👍
Superb technique of teaching.....
Amazing function to use. Thanks a lot for amazing videos!
Excel is too powerful. Excellent video, easy to understand. I see that you are a passionate professor. I enjoy your video. Thx!
As usual very informative, I am already a big fan of lookup function (and yours too) but now it has enhanced it capability to next level.
Thanks for explaining 👍
You're very welcome. It really is much improved.
Extremely informative - thank you.
Really simple yet detailed example. Thanks.
Dear mam, you are a nice tutor and an inspiration for me.
I want to confess one thing, I just learned xlookup because of your beauty 😁, because i saw your photo on thumbnail and it make my mind to watch this video. But thanks for teaching us. Stay happy
As usual, nice video explaining XLOOKUP, which looks promising! Waiting for its general availability!
What a relief not having to count columns to locate the return array. Much better! And glad the default is 'exact match', I cannot recall having had use for anything but.
It really is a major improvement :)
Wonderful, this is more than I expected.
Wow, thanks Leila for giving us an overview of this amazing coming function. You made me love Excel
That's great! I'm glad you joined the club :)
Awesome as always Leila! 👍🏻 thank you 🙏🏻
This is the video i was waiting for 🤗👍. Nice Video Ma'm.
You're an excellent trainer!! You take very technical ideas and explain them that even non-experts can understand!
Thanks for the kind feedback.
Great video. It has great knowledge to learn about Excel.
Am a great fan of your videos. They are really informative. The pace and the way you explain are unique and second to none. Keep up the good work. God bless you always.
Thank you, I appreciate that!
You just saved me an inordinate amount of time. Thanks. Well done.
Glad I could help, Doug.
We have been using such complex VLookups. Cant wait to try out XLookup in our upcoming financial models.
Great little video. Thanks for sharing
Thank you very much, dear lady.
Thanks dear i really appreciate your services.. Fabulous
Thank you Leila, I tried VLOOKUP for the same spreadsheet but kept having issues with it. This worked first time.
Wow! powerful function! I'm happy I found out about it!!!
Wow xlookup is great definitely adding this to my spreadsheets thanks
Thats what we are waiting for. Thanks for the video.
So pleased to find this, even on a Saturday morning