top of page
Search
  • Writer's pictureImran Din

Let’s talk about Se- XLookup, Baby!

So the 80s called, they want their VLookup back.

 

Just kidding, I use VLookup all the time!


To be honest, I like it better than Index/Match.


But today let’s introduce the new kid on the block, XLookup.



A image of a cute looking child wearing warrior armour, weilding a crooked gardening tool.
XLookup

Xlookup is a powerful and surprisingly simple formula to use.


Today, we're working with a list of IDs and Names and we want to return the name of a given ID:



An XLookup formula is easy, nay, super easy to write:


=XLOOKUP(lookup_value,lookup_array,return_array)

Or in "Non Nerd" terms:


=XLOOKUP(whatToLookFor,whereToLook,whatToReturn)

In our example, we're looking in the A column for whatever we type in the E1 cell. And when a match is found, we want to return the name from the B column:


And that's as simple as it gets!



All I would say now is, Max, don't have XLookup with your Ex! Cuz it may make your life complex.

0 views0 comments

Comments


bottom of page