XLOOKUP Excel Tutorial

XLOOKUP Excel Tutorial
Get Ad-Free Training by becoming a member today!
/ @learnittraining
Who it's for: All Excel users, especially those looking for the next best feature.
What it is: XLOOKUP is a powerful new lookup function in Excel, letting users search for and find items in a table faster than ever before.
What you'll learn: First, you'll learn about VLOOKUP and Index and Match, the precursors to XLOOKUP. We'll talk about what makes those functions fantastic and what makes them lacking in certain areas. Then, we'll explain why XLOOKUP is a huge improvement and how to properly use it to level up your Excel performance.
Exercise File: bit.ly/2Pxt3Lq
For ad free training and certificates please join Learnit Anytime:
www.learnitanytime.com
Enroll in our live, instructor-led Excel classes:
bit.ly/3GJWoeV
For Private Group Trainings please visit:
www.learnit.com/private-group...
Exercise File: bit.ly/2Pxt3Lq
Start 0:00
Introduction 0:03
Introduction to VLOOKUP 2:31
VLOOKUP Limitations 10:29
Introduction to Index and Match 14:13
Introduction to XLOOKUP 23:04
XLOOKUP - Approximate Match 28:44
XLOOKUP - Multiple Values Returned 31:14
XLOOKUP - Two Way Search 33:32
Conclusion 37:47
#Xlookup #Excel
(C) 2021 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.

[@JAnder7985]

I finally learnt the Two Way Search using XLOOKUP. It took me awhile but I did it plus some functions which I used for the first time through this interactive video.Thanks!

[@dashjustice1148]

I'm going to go ahead and thank you before he video is even over. - Thank you

[@LearnitTraining]

You are welcome!

[@couragetamakloe4621]

You make learning easy and enjoyable.

[@LearnitTraining]

Thank you so much for the kind words Courage! Great name!

[@jamesanderson348]

These tutorials are great. Keep up the good work!

[@LearnitTraining]

Glad you like them!

[@Kuhrageous]

I love your style of teaching. I've watched many tutorials but always find myself stopping the video half way through because i dont like the style. Please keep making tutorials!

[@LearnitTraining]

Awesome, thank you!

[@dansmith2711]

thank you, learn a lot

[@LearnitTraining]

You are welcome!

[@hakanaltintas1]

Super useful!

[@LearnitTraining]

Glad it was helpful!

[@bouseuxlatache4140]

this was a really good tutorial. bravo!

[@LearnitTraining]

Glad it was helpful!

[@samirsvlogs3626]

jazak Allahu khairan, Faz. i love your videos

[@LearnitTraining]

Thank you for subscribing MD Samir Kabir! It means a lot to us!

[@samirsvlogs3626]

Thanks to you guys for your times which u spent for this costly videos to make us expert in excel. ❤️

[@timmytesla9655]

Wonderful video. Thank you!

[@LearnitTraining]

Our pleasure!

[@shoppersdream]

Thanks for sharing it but I found it very confusing. First In your table for VLookup, I didn't know what did you mean by OLD? We were looking for value from the Gross Column. There was no mention of Gross and second, at 17:22 there was no explanation why did you assign value 1 for Gross Column/Array. (We are using this column as Array) You were talking about Array how it starts at 0 and then suddenly I am seeing 1,2,3, next to Gross columns. It really confused me. Not sure if I will watch the whole video. Thanks

[@aziquaderi]

@Learnit Training Faz, this was a great and helpful session . On your presentation you demonstrated the lock-up functions within one sheet, where all the datas are in one sheet. My struggle is to find someone showing and explaining vlook up and xlook up between 2 or more Excel sheets. Do you have that available?

[@LearnitTraining]

Awesome, thank you!

[@aziquaderi]

@@LearnitTraining you did not answer my question.

[@blackwhite2361]

@@aziquaderi🤣🤣🤣🤣🤣🤣. What he means is that your question is awesome 🤣🤣🤣🤣🤣🤣🤣🤣🤣

[@sean1uncut]

Fantastic FAZ

[@LearnitTraining]

Thank Sean for watching and an extra big thank you for subscribing!

[@elainestewart7188]

Thank you for the course provided. How do I sign in to the sharepoint to access & download exercise sheets?

[@LearnitTraining]

Hi Elaine - the link to the exercise files is in the video description

[@elainestewart7188]

@@LearnitTraining I see this, however, I am asking how to sign in.

[@adaezekatchy4341]

Your videos have been helpful, thank you. I can't access the exercise file, it's showing that's it's broken

[@LearnitTraining]

Hi Adaeze! We just tested the link and it is working currently. Please be sure you are using a computer that can access Onedrive files

[@adaezekatchy4341]

@@LearnitTraining I've been able access the file now, thank you

[@ubaidillahmuhammad20]

nice job. May i have the excel file, sir?

[@LearnitTraining]

bit.ly/2Pxt3Lq

[@francescotagliavento8081]

Can you upload the exercise file ? thank you

[@LearnitTraining]

bit.ly/2Pxt3Lq

[@francescotagliavento8081]

@@LearnitTraining thank you

[@karuthirumankumaraguru9253]

above formula not working in my excel sheet. how to activate in my system?

[@adarshkulkarni9754]

Check the version of Excel you have. It works on Office 365.

[@mikelennon1078]

I have 3 worksheets (tables) in a workbook). 1- Companies with 10 field including name, address, website, . 2- 2- Contacts with names, company names, title, phone number and email address. 3- Opportunities including names, address, etc. and companies which are working on any particular project and that is all. 4- Each sheet or table can have 100 to 10,000 records (Contact worksheet has the most) What I am trying to achieve is when selecting a company name (either from drop down box or...) see the records of all its employees and its opportunities if there are any also be able to edit or update the extracted values, if needed. Can someone help me by showing me how these can be done via VBA, or Power Lookup or any other means. I would appreciate it.

[@BharatSingh-lt5pz]

Is this full course of excel in your playlist after learn all your playlist can I get job in mis please tell me please

[@adarshkulkarni9754]

Having an experience of 4+ years, I would say, It's a part of excel and all the videos of Learnit are not sufficient to get job! You need to do the Excel certification. In addition to that if you could do Tableau or Power BI and Service now it will be an added advantage to get a job. Excel is most basic tool used in small scale industries. Good luck!

[@francescotagliavento8081]

in which field?

[@adarshkulkarni9754]

@@francescotagliavento8081 he is referring to MIS reporting field it seems.

[@BharatSingh-lt5pz]

@@adarshkulkarni9754 hey adarsh thank a lot for your reply and sharing knowledge ,. But can you tell me please from where I can get full course where I can get job in mis or I can learn all things in ms office like excel word and PowerPoint ,but if possible in cheap. Please please

[@BharatSingh-lt5pz]

@@francescotagliavento8081 mis field

[@Anglegirl713]

The files is already completed and do not allow deletion of the fields.

[@LearnitTraining]

Hi Frances! You can download a local copy and make any changes you wish!

[@asiaja1831]

We can change #N/A with function if(isna(match(,,,)),"",match(,,,))

[@unknown-ss4rl]

11

[@ominisxxx]

I guest it only worked for Excel 2010, as 2016 didn't have for this fuction

[@LearnitTraining]

Hi Yoga this function was added just recently and works with Office 2019 or Office 365

[@ominisxxx]

Oh i thought so. Thank you for your information, i really appreciated for it

[@tomyfrancis7566]

great video except for that blue bar at the top and bottom of the video.

[@LearnitTraining]

Noted!

[@ashutoshpandey183]

Xlookup replaced vlookup,index+match, vlookup+match, vlookup+match

[@rubenlomudi2088]

Lomudi Ruben 8 years ago Logistics industry Matrix 2:7

[@ImSurvivingStill]

no such thing as muscle memory... it is brain memory

[@LearnitTraining]

Noted!