Using XLOOKUP in Microsoft Excel

Home / Hints & Tips / Using XLOOKUP in Microsoft Excel

Have you ever wanted to create data based on other data in Microsoft Excel, but were unsure exactly how to go about it?

If so, you need the XLOOKUP function, which allows you to find things in a table or range by row, and return a matching result.

XLOOKUP is relatively new to Excel – it’s versatile, flexible and easy to use, and offers much more than similar functions, such as VLOOKUP.

To help you, we’ve put together this step-by-step, easy-to-follow guide on how to use XLOOKUP. In the short video below, we’ll show you:

· How to look up values in tables and return them into cells based on other cell values. For example, you may want to update a cell for a region based on who the sales manager is, or perhaps based on the address

· Use both partial and exact matches

· What to do if you get an error in your formula

· Know the differences between absolute cell references and relative cell references

Watch the video below as we take you through a practical example using XLOOPUP, that you can apply in your own spreadsheets.

We’re here to support you every step of the way, and our friendly team are here waiting to help and assist you. 

We’d love to hear from you, so please email us at, give us a call on 0121 384 2513, or click the ‘Contact Us’ button below and a member of our team will get back to you as soon as possible.