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
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
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.
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!
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!
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@@@@@
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.
@@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.
@@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.
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 :)
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!
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.
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 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!!!!
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@@@@@
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 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
"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."
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.
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! :)
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.
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 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?
@@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..
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
Hi Leila, I am your big Fan, I have learned lot from your video (Udemy).. you are doing great Job.. your videos are very simple to understand as compared to others tutors.
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.
i'm really looking forward to getting this. I'd like to see it ported to 2010, since that's the version of Office my company uses. As easy as this makes my life (and it will make it easier), I suspect I won't get much use from it because I'm constantly moving Excel files between multiple versions, so I have to use functions that work across every excel version I might use so nothing breaks. My office computer uses 2010, my jobsite computer is on 2013, my home computer is 365.
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 !! ☺️
I always used Index/Match, until I got annoyed by having to switch between sheets/workbooks to select all the data needed. That's why I added the function below to an add-in about a year ago. Looks a lot like the Xlookup function I see now .. Since I don't have the fancy latest Excel, i'll keep on using my own ;) Function JD(SV, CS, CR) 'SV: Search Value, CS: Column Search, CR: Column Return JD = WorksheetFunction.Index(CR, WorksheetFunction.Match(SV, CS, 0), 1) End Function
Leila Gharani The only issue is it takes so long for these things to appear in the main version of Excel unless you’re an Office Insider. I first learned about dynamic arrays last year, but it still hasn’t appeared yet!
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
‘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!
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
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!
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?
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.
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.
Thanks Leila for introducing this fantastic feature and thanks to the Excel team engineers. You've made the life easier for us!
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 :)
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!
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.
Thanks
Thank you!
What is more beautiful - this new XLOOKUP or Leila? Xlookup is awesome but Leila is unbeatable ;)
download tinder asap and find yourself a lady
Madam, thank you so much. Your communication is just outstanding.
The Xlookup is a genius override on Vlookup. Put a bar on that function already :)
Thanks Leila!
😁 excel has come a loooooong way, I remember when I started with Lotus in 1988 and it seemed super powerful then
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 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!!!!
just try it and really usefull...this lookup from right to left really help me alot.thx
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@@@@@
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.
XLOOKUP is quite easy to use, thanks Leila
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
Great video about the new X function, Teammate!!!
Thank you teammate Mike. I love your XL version!
I'm also subbed to your channel. 👍
I started with vlookup and graduated to index and match. Sorry, I'm leaving both behind for XLookup....its a lot easier and efficient.
That's a nice journey :)
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 ;)
Thank you Leila, I tried VLOOKUP for the same spreadsheet but kept having issues with it. This worked first 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."
I thoroughly enjoy your videos! You are a very good teacher!
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.
Game changer!
Your videos have me the epiphany that my Excel knowledge is outdated.
Very humbling.
What is the use of explaining this function as it still is not available? Will it ever become available?
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 :)
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!
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.
Thanks very much. I hope Microsoft update this function to all office
I have been watching your videos for a few years now, and I am always learning something new. Thank you :)
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
Never seen anyone use this helpful feature. Thank you Leila
RIP VLOOKUP
1979 - 2019
Muchas Gracias, has hecho mi vida mas facil con este video, thank you you have made mi life easier with this video, truly appreciated
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@@@@@
"If you're excited about this, hit that thumbs up!"
*ROBOT VOICE* "Yes, I am excited"
I'm glad to hear that :)
I'm a big VLOOKUP user...I didn't knew about this new XLOOKUP. Is wonderful. Thanks for the tutorial
The Xlookup is new. It exists since August/28/2019.
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
Dear mam, you are a nice tutor and an inspiration for me.
WoW!♥️♥️♥️💖💖💖,no counting of cells,RIP VLookup
Thank you! Had difficulty getting this function to work before watching your video. This helped a ton!
Glad it helped!
so...how does this stack up against Index/Match? that's all i ever use, haven't used vlookups in a long time.
Excel is too powerful. Excellent video, easy to understand. I see that you are a passionate professor. I enjoy your video. Thx!
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.
Can I use the INDIRECT function on XLOOKUP? Thank you.
Sounds like the name of a shady website.
Xlookup - spread your sheets like you never did before
XXX LOOKUP
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.
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..
I was getting N/A error while using Vlookup but with this it works perfectly. Thanks alot. :-)
Correction : Kim West doesn't have a job!
Thank you Leila, Every Thursday I celebrate as Learning day, its because of you, i learn new things, I really want to Thank you for your videos
Happy Excel Thursday :)
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
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!
We have been using such complex VLookups. Cant wait to try out XLookup in our upcoming financial models.
This is so cool. Been struggling with COUNTIF and COUNTSIF fx. This will make my life easier.
Hi Leila, I am your big Fan, I have learned lot from your video (Udemy).. you are doing great Job.. your videos are very simple to understand as compared to others tutors.
I'm happy to hear that. Many thanks for your support.
Wonderful, this is more than I expected.
You're an excellent trainer!! You take very technical ideas and explain them that even non-experts can understand!
Thanks for the kind feedback.
i love it you made simple and clear thank you Leila
Brilliant as always. So easy to follow and always informative
GREAT VIDEO! And the best trick I got out of it...never knew the "F4" shortcut for locking cells. So many moments have been wasted.... 😞
Awesome tutorial.
How do you Drag & Drop as seen @5:25
You just saved me an inordinate amount of time. Thanks. Well done.
Glad I could help, Doug.
Thank you, short n sweet, up to the point
Leila Gharani I was waiting for your video on Xlookup and believe me you explain it the best ❤️thanx
I'm very happy to hear that Farrukh :)
Leila Gharani 😍
Lovely.. That's so crisp & clear... U r awesome 👍
So pleased to find this, even on a Saturday morning
Great video. It has great knowledge to learn about Excel.
Wow xlookup is great definitely adding this to my spreadsheets thanks
I used it to replace an Index/Match with multiple criteria. Chain the criteria with an ampersand and do the same for the lookup array
Brilliant, this saves all the prepping of data to put it into the right place and order to work
Thanks again for your simple and prompt explaining
Superb technique of teaching.....
Leila you are absolutely amazing for this. I hope your blessings multiply 👌
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!
OMG, you just made my job so much easier and efficient, thank you!
Great little video. Thanks for sharing
i'm really looking forward to getting this. I'd like to see it ported to 2010, since that's the version of Office my company uses. As easy as this makes my life (and it will make it easier), I suspect I won't get much use from it because I'm constantly moving Excel files between multiple versions, so I have to use functions that work across every excel version I might use so nothing breaks. My office computer uses 2010, my jobsite computer is on 2013, my home computer is 365.
Agree - working with different versions is a big issue....
you explained it very well... thank you
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 !! ☺️
I always used Index/Match, until I got annoyed by having to switch between sheets/workbooks to select all the data needed. That's why I added the function below to an add-in about a year ago.
Looks a lot like the Xlookup function I see now .. Since I don't have the fancy latest Excel, i'll keep on using my own ;)
Function JD(SV, CS, CR)
'SV: Search Value, CS: Column Search, CR: Column Return
JD = WorksheetFunction.Index(CR, WorksheetFunction.Match(SV, CS, 0), 1)
End Function
Nice. For an alternative
ua-cam.com/video/CKVTaJq3B2k/v-deo.html
ua-cam.com/video/0B9cc7shvoI/v-deo.html
Wow! powerful function! I'm happy I found out about it!!!
Hi Leila, thank you for sharing your wealth of knowledge. Your videos are very helpful. ❤️❤️❤️
My pleasure Anne. I'm glad you like the tutorials :)
Thanks dear i really appreciate your services.. Fabulous
Really simple yet detailed example. Thanks.
This is a game changer. Thank you!
Hi Leila, Your videos are awesome. Thank you for your teachings!
It’s another game changer, just like dynamic arrays. Thanks for sharing this, Leila!
It sure is Andrew. I'm very excited about it.
Leila Gharani The only issue is it takes so long for these things to appear in the main version of Excel unless you’re an Office Insider. I first learned about dynamic arrays last year, but it still hasn’t appeared yet!
True. I still haven't given up hope though both will be released together before year end ... 2019 that is :)
This is absolutely brilliant! Thank you so much for posting.
You are my 'go to' excel expert. Thanks for shsring your time 😷👍
Wow, thanks Chris!