Adding XLOOKUP Function to Excel 2013-2016 | How to get the XLOOKUP Function to work in Excel

How to add the XLOOKUP Function in Excel. You will be able to unlock all the great features of XLOOKUP in Excel 2013 - 2019. Before this add in tool XLOOKUP was only available to Microsoft 365 subscribers.The Xlookup function is a power full tool and replaces Vlookup, Hlookup, Match, Index and Lookup functions.

Below is the link to download the XLOOKUP files for 32-bit and 64-bit.

Steps:
1. Download the file
2. Open Excel Blank workbook
3. Click files
4. Click Options
5. Click Add in
6. Click Go button
7. Click Brows and select file (based on your excel version)
8. Click Ok
9. Test it out

Make sure to what the video below on how to use the XLOOKUP Function.

[MarkDeMoss]

Thank you for this XLOOKUP add-in. I use XLOOKUP extensively on my work computer, but needed to use it on my personal computer with Excel 2019. Now it works in my Excel 2019! You saved me from the cost of upgrading to Office 2021 on my personal computer. THANK YOU!

[andreivesa]

life saving video, if the company hasn't upgraded yet to office 2019.Thank you!

[arttiezgaming]

Thank you for your solution ! I can use on office 2019.

[finsultants]

Thanks a lot for solving the XLOOKUP problem.. I have a 2013 version & its now having Xlookup working well

[ricosihotang]

Finally I got it. Now I have Xlookup menu. Thank you STB 81

[CharbelKhalil]

Hello, I am a new subscriber. Thank you for the great help with XLOOKUP add-in function solution you provided, I am a user of Office 2019 and always wished to have it included in my office version. Thank You

[weronikaes]

Thank you so much for saving my life!!! We need more people like you who help us by sharing their knowledge

[stevedachelet]

Thank you! I was able to get the Add In working as a test in Excel 2013. I have someone that wants to use it in Excel 2016 and thought I was going to have to switch them to 365, to use xlookup and xmatch. Both show up in Excel DNA functions now.

[yuvalshechori]

Awesome!! I had work I needed to do on my personal computer instead of the work laptop, was getting scared I won't be able to use this which would mean a whole world of headache. So thank you, works perfectly!

[satishbone]

Thank you so much for sharing this clue for add in xlookup

[crusaderzero]

Thank you so much for sharing this knowledge & the add-in. We need more accommodating people like you sir! 👏

[arnoldochris]

works like a charm, thank bruv you a life saver

[abdullahkhan-qklk]

Very Helpful, Worked without an issue

[predragvuckovic]

Thanks for explaining the process. Works!

[hanifcesarioabdullah]

Thank you so much bro for sharing with us. it really works on me ! have a nice day

[md.tanwir]

Thanks STB 81, it is working fine with me. Gr8 job. Really appreciate it.

[ozlemince]

THANK YOU SO MUCH:))) IT'S GREAT TO HAVE THİS FUNCTİON WİTHOUT GETTİNG OFFİCE 365, SO MANY THANKS

[LamborghiniChallenger]

Thanks sir! very useful... Hope you will keep it up your work!!!

[marouaneramdani]

Thank you
I need filter function please