XLOOKUP Add-in for Excel 2013, 2016 and 2019

preview_player
Показать описание
In this tutorial, we will show you how to use the XLOOKUP function for all Excel versions.

The XLOOKUP add-in enables you to use the only Microsoft 365 compatible function under Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

Everyone wants to use XLOOKUP. However, if you are not a Microsoft 365 subscriber, we have some good news: Our add-in uses a user-defined function to keep your Excel up to date.

Download the XLOOKUP add-in:

Chapters:

0:00 - Intro
0:06 - How to install the XLOOKUP Add-in
0:31 - Left Lookup Example using XLOUKUP
0:57 - Function library for Microsoft Excel

Using the .NET Intellisense integration, the add-in provides native Excel tooltips. Once the add-in is installed, you can use the DXLOOKUP function. It is equal to the Microsoft 365 version.

#excel #xlookup #excelautomation #msexcel
Рекомендации по теме
Комментарии
Автор

Damn! Worked like a charm, thanks a ton 🙏

Ajaysingh-kzth
Автор

Thank you for this video... It is a all time big saver. GUYS YOU MIGHT FIND ERROR... WHEN U CLICK OK JUST " DISABLE MACROS" and u r good to go

darshitgadhiya
Автор

Hello😊 could you add the add ins for sort, textsplit & randarray functions.

sakky
Автор

I have excel 2016.
in this version xlookup don't work.
can u tell that the xlookup and dxlookup have the same function or not?

viupdtb
Автор

Hi, its working!

How can use install adds to use in another tab?

kenzoarakaki
Автор

Pls help me this function is working but can't function arguments

tohirqurbonboyev
Автор

in my excel, Developer tab is not there ... LOL.. firstly I will check how to activate or see Developer tab

mailmesahil
Автор

Just by looking at names of commenters, I got suspicious. All has at least one number in their name, very usual for sure...

icesphere