Everything You Need To Know About XLOOKUP

Learn everything you need to know about the new XLOOKUP function in Microsoft Excel with 10 examples.

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

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

[duncanwil]

Another good video, John. I know it might not be practically so wonderful but starting at 5:15 you talk about a mixed XLOOKUP() example where you tried to find a result using a mixture of vertical and horizontal lookups ... This works, =XLOOKUP(B2, D4:D6, TRANSPOSE(E2:G2))

[wayneedmondson]

Hi John.. cool summary of the new XLOOKUP function. I especially like the nested XLOOKUP example and returning a range with two XLOOKUPS and the colon operator. Great stuff! Thumbs up!!

[sarahpaty]

What does "exact match" and "approximate match" mean? You jumped straight to using those words, without defining them. Can you please define what they mean before jumping straight to how to use them? Thank you in advance.

[glennthomas]

Hi John- Your "about section" seems incomplete. Like to know more about your services. Glenn

[netrapalyadav]

Thanks for sharing valuable information about XLOOKUP. My excel has MICROSOFT OFFICE 365 ProPlus Version 1902 (Build 11328.20438). But unable to find this function. Please help