Grab the file I used in the video from here 👉 pages.xelplus.com/xlookup-explained-file Check it out XLOOKUP with even more examples: kzread.info/dash/bejne/Zpdkpa6OdbWcnto.html

@PeggywongPeggy

4 жыл бұрын

But Leila, I have try it is not working at my end

@PeggywongPeggy

4 жыл бұрын

"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

@PeggywongPeggy

4 жыл бұрын

in my excel I try to look for xlookup it does not have it

@PeggywongPeggy

4 жыл бұрын

this format can work in ms office which year?

@bencipherx

4 жыл бұрын

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”.

@achach228

4 жыл бұрын

Lol me right now

@TheMentalFitChick

4 жыл бұрын

Totally agree!! And excited to use it at work on Monday lol

@thamonito

4 жыл бұрын

Omg today is Saturday and I am watching this for fun. Well, I guess that proves it I am a nerd lol

@chucksim2063

4 жыл бұрын

Right there with you except it's Sunday when I am watching this video

@masturazainudin5410

4 жыл бұрын

Exactly me right now lol

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!

@LeilaGharani

4 жыл бұрын

It definitely will!

@diegomilenkovega2840

3 жыл бұрын

Lol I thought Ms meant Miss Excel and that that was her nickname or online persona. ,🤐

@keithau8159

3 жыл бұрын

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@@@@@

@ArmanViews

3 жыл бұрын

Is it possible in xlookup that if it doesnt found any value it doesnt change the current value?

I needed this 3 jobs ago. Wow! Love it.

@prsekharreddy3874

4 жыл бұрын

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

@kcampos888

4 жыл бұрын

lol

@keithau8159

3 жыл бұрын

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 Xlookup is a genius override on Vlookup. Put a bar on that function already :) Thanks Leila!

Great video about the new X function, Teammate!!!

@LeilaGharani

4 жыл бұрын

Thank you teammate Mike. I love your XL version!

@StaticBlaster

2 жыл бұрын

I'm also subbed to your channel. 👍

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 :)

Thanks Leila for introducing this fantastic feature and thanks to the Excel team engineers. You've made the life easier for us!

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!!!!

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.

@LeilaGharani

3 жыл бұрын

Thank you very much!

Superb!

@keithau8159

3 жыл бұрын

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@@@@@

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.

This is absolutely brilliant! Thank you so much for posting.

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

XLOOKUP is quite easy to use, thanks Leila

Hi Leila, Your videos are awesome. Thank you for your teachings!

Have been through so many similar channels. Yours stands out. Good Luck!

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 😊

@rgsoni

2 жыл бұрын

I am trying to drag and drop between cells but cannot (it tries to overwrite). How does it work?

@manojkt190

2 жыл бұрын

@@rgsoni Press "Shift" button when you drag and drop!

@rgsoni

2 жыл бұрын

@@manojkt190 Thank you. I did figure out by trail and error after I posted the question. Appreciate your reply.

@Toommy78

2 жыл бұрын

@@manojkt190 How do you insert columns with drag and drop + Shift? it looks like it always inserts rows.

The concept is very similiar to Index and match function. I enjoy it.

@keithau8159

3 жыл бұрын

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@@@@@

This is the video i was waiting for 🤗👍. Nice Video Ma'm.

I thoroughly enjoy your videos! You are a very good teacher!

Thanks very much. I hope Microsoft update this function to all office

Very nice. Perfect for everyone who never got into the Index & Match functionality.

@melsheanno

4 жыл бұрын

Index and match are just 🤯🤯🤯

@alexblas3986

4 жыл бұрын

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.

@reginaldpetalcorin8546

4 жыл бұрын

@@melsheanno index and match is super easy.

@melsheanno

4 жыл бұрын

Reginald Petalcorin with practice. I recently learned excel and haven’t practiced it so I need some time before finding it easy.

@yokowasis

4 жыл бұрын

Index match is easy. But it isn't any easier than xlookup.

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 love your videos! Definitely my go to channel whenever I encounter excel needed help. Thank you for coming up with such great content! 😍

@LeilaGharani

4 жыл бұрын

I'm happy to hear this. It's great to have you here.

When is the funeral for VLOOKUP? I would like to attend.

@qarniru8341

4 жыл бұрын

Vlookup, Hlookup, Mach, Index RIP

@christoslefkimiotis9889

4 жыл бұрын

and HLOOKUP

@AdamicWay

4 жыл бұрын

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!

@wmfexcel

4 жыл бұрын

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! :)

@ckokse

4 жыл бұрын

@@AdamicWay Haha, it sure did save me a LOT of times. No X-Factor though. I'm jumping ship man!

I have been watching your videos for a few years now, and I am always learning something new. Thank you :)

Awesome as always Leila! 👍🏻 thank you 🙏🏻

Shortcut of index match. Thank you for tutorial.

@LeilaGharani

4 жыл бұрын

Yeah, an easier alternative :)

@ISqueezeMyTomatoes

4 жыл бұрын

@@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.

@robpickles3736

4 жыл бұрын

@@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.

@juanpablopenaloza5093

4 жыл бұрын

I agree!

@ISqueezeMyTomatoes

4 жыл бұрын

@@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.

Thank you so much. I will no longer use =Index(match) :)

@Jonkin59

4 жыл бұрын

Still have to use it for a while as long as its not availiable to all users ;)

This is quite amazing. Thanks for these tutorials.

Backward Vlookup with ZtoA , I love it. Thanks for sharing

a good alternative of INDEX+MATCH combo but, does XLOOKUP has the same problem of huge RAM usage as other LOOKUP family functions?

@daeh49

4 жыл бұрын

vlookup algorythm changed in 2018 to increase speed of linear searches.

RIP VLOOKUP 1979 - 2019

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.

@LeilaGharani

4 жыл бұрын

My pleasure Roberto. I'm very excited about it so I'll definitely expand on this.

Amazing function to use. Thanks a lot for amazing videos!

What is more beautiful - this new XLOOKUP or Leila? Xlookup is awesome but Leila is unbeatable ;)

@wthighlights1170

4 жыл бұрын

download tinder asap and find yourself a lady

What is the use of explaining this function as it still is not available? Will it ever become available?

Wonderful! So clear when you do your videos.

I've seen a couple of other videos about xlookup but yours is the best so far. Keep it up!

@LeilaGharani

4 жыл бұрын

Thanks for the kind feedback Bobby.

WoW!♥️♥️♥️💖💖💖,no counting of cells,RIP VLookup

so...how does this stack up against Index/Match? that's all i ever use, haven't used vlookups in a long time.

Game changer! Your videos have me the epiphany that my Excel knowledge is outdated. Very humbling.

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.

so if someone else comes into the file and re-sorts the division table its still gonna screw up xlookups

@amaniramahi

4 жыл бұрын

I searched some pages for this new function and found that we can sort arrays. Hope someone can confirm this

"If you're excited about this, hit that thumbs up!" *ROBOT VOICE* "Yes, I am excited"

@LeilaGharani

4 жыл бұрын

I'm glad to hear that :)

Leila, this is next level stuff 🙌🏾

‘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.

@LeilaGharani

4 жыл бұрын

You are so welcome Martin!

"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’m sorry but index/match killed vlookup years ago

@harshchovatiya-gh7hn

4 жыл бұрын

TryvReanimation Jutshu...than kill it again

@Robert256

4 жыл бұрын

Offset/match killed index/match shortly thereafter

@jofx4051

4 жыл бұрын

Double kill for Vlookup/Hlookup

@vishalbhati912

4 жыл бұрын

But I always use vlookup

@mandeeprai9818

4 жыл бұрын

VISHAL BHATI stahp

I can't wait to see this release thanks for this tip

Finally, I have been waiting for your video on this. Thanks Leila

@LeilaGharani

4 жыл бұрын

I hope you like it.

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?

@jonathanlee7355

3 жыл бұрын

Funny how that works...lol

@mondaymendoza1239

3 жыл бұрын

This is something i have been pissed about for years. It is like that for the whole world. Shitty.

I'm only learning to so I can say " The only time I look up for my X is on Excel " :)

@LeilaGharani

4 жыл бұрын

😂

@leedreamz

4 жыл бұрын

@@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..

@satyanarayanyadaw2447

4 жыл бұрын

@@leedreamz Try PPMT and IPMT functions

@leedreamz

4 жыл бұрын

@@satyanarayanyadaw2447 thank you.. will try and update..

Your videos are absolutely brilliant. Straight to the point and exactly what you’re looking for. Thank you so much

@LeilaGharani

3 жыл бұрын

Glad you like them!

Brilliant as always. So easy to follow and always informative

Sounds like the name of a shady website.

@adhominem_

4 жыл бұрын

Xlookup - spread your sheets like you never did before

@georgeem8924

4 жыл бұрын

XXX LOOKUP

Correction : Kim West doesn't have a job!

Wonderful, this is more than I expected.

WOWWWWWWW, man can't ask for more! Bless you dear!

At first I thought it would be some kind of porn ad

@jofx4051

4 жыл бұрын

Someone's mind is going too far

@dilleswararaomandala465

4 жыл бұрын

That one is not human being, some thing different I think

Thats what we are waiting for. Thanks for the video.

So good! This is life changing ❤️❤️❤️

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.

@LeilaGharani

4 жыл бұрын

I think so too. Once it's available for everyone on Office 365 it will be one of the most used functions.

As usual, nice video explaining XLOOKUP, which looks promising! Waiting for its general availability!

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!

@LeilaGharani

4 жыл бұрын

Then you'll definitely love the new functions. Great to have you here Adam!

Wow, thanks Leila for giving us an overview of this amazing coming function. You made me love Excel

@LeilaGharani

4 жыл бұрын

That's great! I'm glad you joined the club :)

This is great! Hopefully I'll be able to use it soon.

Leila you are absolutely amazing for this. I hope your blessings multiply 👌

Never seen anyone use this helpful feature. Thank you Leila

Thank you, short n sweet, up to the point

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 👍

@LeilaGharani

4 жыл бұрын

You're very welcome. It really is much improved.

Brilliant, this saves all the prepping of data to put it into the right place and order to work

Thank you! Had difficulty getting this function to work before watching your video. This helped a ton!

@LeilaGharani

3 жыл бұрын

Glad it helped!

Awesome! I am so used to VLookup, but this XLookup is a must for me.

Very useful...thanks a lot Leila

Thank you. love to watch your videos.

Lovely.. That's so crisp & clear... U r awesome 👍

Muchas Gracias, has hecho mi vida mas facil con este video, thank you you have made mi life easier with this video, truly appreciated

This is a great thing.... Thanks for your help... You are great

Brilliant as usual and as stated below, better than Index/Match when you have to find the last match in a list.

Really interesting. I all ready know where I can use this new fonction. Thanks a lot

Wow! cant wait to use it! Thanks Leila!

i love it you made simple and clear thank you Leila

Really simple yet detailed example. Thanks.

So pleased to find this, even on a Saturday morning

Cant wait to get access. Thanks Leila!

Madam, thank you so much. Your communication is just outstanding.

This is a game changer. Thank you!

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.

@LeilaGharani

4 жыл бұрын

Yeah, these tricks are not needed anymore :)

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.

@LeilaGharani

3 жыл бұрын

Thank you, I appreciate that!

What a jaw dropping update! I'm really amazed by it

@LeilaGharani

4 жыл бұрын

I'm also excited about it :)

Thank you for tutorial! very useful tip.

Oh you tease Leila! :) Thanks for sharing! I shall look forward to XLOOKUP being available!

@LeilaGharani

4 жыл бұрын

And rightly so Steve :)

Extremely informative - thank you.

Great video. It has great knowledge to learn about Excel.

Excel is too powerful. Excellent video, easy to understand. I see that you are a passionate professor. I enjoy your video. Thx!

That's going to save me a lot of time. Thanks!

OMW. I feel so clever 😄 This is amazing!!!

You're an excellent trainer!! You take very technical ideas and explain them that even non-experts can understand!

@LeilaGharani

4 жыл бұрын

Thanks for the kind feedback.