Linnworks

SellerHub.TV

Ecommerce | Marketing | Business

No More Vlookup, XLOOKUP Is Here

  • 34 Years In The Making
  • No More Complicated Formulas
  • VLOOKUP Just Made Easy
  • =VLOOKUP(J5,B:E,4,FALSE) vs =XLOOKUP(N5,B:B,E:E)
xlookup formula

“Excel formulas, Charlie this is hardly exciting?” I hear you say.
Well, I beg to differ! Especially in the world of ecommerce, with big catalogues and lots of data, lookups for the time savvy are crucial!

Actually scrap that, I want to change my statement… Lookups go far beyond just product data, so much so that there are a number of scenarios and industries which would need to perform a Lookup function.

Don’t believe, well according to Microsoft, VLOOKUP is the 3rd most used function (after SUM and Average) and it is not hard to see why as it allows the user to find data from one table or range and populate it on another. #MindBlown

If you haven’t witnessed the power of a Lookup fuction here is an example of how one could use it.

You are listing 10 products on Spreadsheet A, so far you have populated the SKUs.
On Spreadsheet B, you have the 10 products pricing, barcodes and dimensions among a list of 5000 products.
So rather than trawling through Spreadsheet B, copying and pasting across to Spreadsheet A, you use a VLOOKUP and use the SKU as the reference which auto-populates the data based on your formula.

So why XLOOKUP?

Well VLOOKUPs is one of those formulas that once you get it, you get it and it seems quite simple but if we are all honest, it does seem overly complicated for what the user wants to achieve.

It can also be quite hard to explain to someone who has not used it before and if not used often, it is quite easy to forget the difference between False and True, or that the column numbers represent the selection rather than the whole spreadsheet.

XLOOKUP has got rid of the unnecessary inputs and has a simple method of asking you to tell Excel What you are looking for, where to find it and what to return.

Excels XLOOKUP
XLOOKUP function in action

As you can see in the image above, to find the country code, the user uses the formula =XLOOKUP(F3,B3:B12,D3:D12), to achieve the same result in a VLOOKUP, you would have to write the following =VLOOKUP(F3,B3:D12,3,FALSE).

The main reason I am excited is not the fact it will save me time (I’m well versed in the world of lookups) but it will be so much simpler to explain the concept of an XLOOKUP to the business owners and their teams I work with. Ultimately it will be easier for their teams to embrace the use of lookups and become more productive in doing so.

Want to learn more?

Want to learn more? Below I’ve included some useful links

https://techcommunity.microsoft.com/t5/Excel-Blog/Announcing-XLOOKUP/ba-p/811376
https://www.mrexcel.com/excel-tips/the-vlookup-slayer-xlookup-debuts-excel/
https://www.excel-university.com/xlookup/