Data Fidelity

How To Add XLOOKUP Function to LibreOffice Calc

This tutorial will explain in short how to make LibreOffice Calc able to do XLOOKUP by adding an extension called Lox365. It will give you abilities of xlookup and more features like Excel. We would love to say thank you very much to the developer, Goose Pirate, for creating it. 


Subscribe to UbuntuBuzz Telegram Channel to get article updates.


1. Visit Lox365 Web Page

[ Visit Website ]

2. Download Extension

Find there Releases section and download the file with .oxt extension. 

3. Install LibreOffice Extension

Click the file with .oxt extension >  LibreOffice will show > Extension Manager will ask you permission to install it > click OK. 

4. Restart LibreOffice

Select Restart LibreOffice if you are asked to do so. 


5. Use XLOOKUP in Calc

Now XLOOKUP function is ready to use in Calc. You can use it as in Excel. 



Lox365 Extension (The Document Foundation)


This article is licensed under CC BY-SA 3.0.

More In Technology News

Contact Data Fidelity

Send us a quick message, and we will endeavour to contact you as soon as possible. 

Alternatively, feel free to use our complimentary Quote Tool service to find our how much a new website will cost you today.

Contact Us

Take control of the internet

Download a FREE copy of our E-book, covering:

  • Origins of the internet, CERN & The GNU Philosophy
  • Misconceptions around the internet & its best practices
  • Database Architecture & Design
  • Exiting Big Tech
Book Subscription
Skip to content