XLOOKUP Excel Tutorial

XLOOKUP Excel Tutorial

Get Ad-Free Training by becoming a member today!

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.

For ad free training and certificates please join Learnit Anytime:

Enroll in our live, instructor-led Excel classes:

For Private Group Trainings please visit:

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.

[JAnder]

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!

[dashjustice]

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

[jamesanderson]

These tutorials are great. Keep up the good work!

[bouseuxlatache]

this was a really good tutorial. bravo!

[adaezekatchy]

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

[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

[samirsvlogsu]

jazak Allahu khairan, Faz. i love your videos

[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?

[mikelennon]

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.

[elainestewart]

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

[francescotagliavento]

Can you upload the exercise file ? thank you

[karuthirumankumaraguru]

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

[ubaidillahmuhammad]

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

[Anglegirl]

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

[BharatSingh-ltpz]

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

[ashutoshpandey]

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

[tomyfrancis]

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

[asiaja]

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

[rubenlomudi]

Lomudi Ruben 8 years ago
Logistics industry
Matrix 2:7

[ImSurvivingStill]

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