Skip to main content

XLOOKUP Formula in Excel(Much Better formula than hlookup and vlookup)

 


This is one of the most powerful formulas that you can use when you find values in an Excel table. Certainly, you haven't heard about it because it was released in 2016. As you have probably read in my previous post about HLOOKUP and VLOOKUP. Otherwise, please check this post first and come back here.

IN SHORT:

  • HLOOKUP will be used when you have a horizontal reference table,
  • VLOOKUP when you have a vertical reference table. 
  • XLOOKUP will be used in any case. 

EXAMPLE

Suppose that you have a table as in the top of this post and you are looking for the values for John. John's age is 17 and height is 199 cm. And if you have a table of 1000 people. It will be really tough to find the exact value in a short time. 

Now, you need this formula:

=xlookup(A4, A2:A5, B2:C5)

Here is what each argument means:

  • The first argument(A4) is the cell name of "John". 
  • The second argument is the area that "John" belongs to.
  • The last argument is the output area that contains the age and height value.

The final value after you press the Enter button will be 17, 199

This is a really easy and simple formula everyone should know as an accountant, a paralegal, or a secretary. My post will cover the information that can be used for your daily jobs and make your daily tasks much more efficient.

Even though we have AI to make our jobs easier, we need to understand the structure and flow of the job process. I have seen many students who just use the formulas as a template and don't understand the structure of it. Please take the time to learn the basic structure behind each formula and think creatively about how to apply it.

I will try my best to help you and make our lives meaningful. I hope you'll visit my blog once a week to learn something new.

Have a great day!

* The top image is a screenshot of an Excel file.


Labels:

Comments

Post a Comment

Popular posts from this blog

My Journey: From Korea To Canada

About 27 years ago, my family and I made one of the biggest decisions of our lives—we immigrated to Canada. Like many newcomers, we came with hope, determination, and dreams for a better future. Our primary goal was to provide a better education for our children, a happier and more stable life for our family, and greater career opportunities for me. Although we were excited about the future, starting over in a new country was never easy. Everything was unfamiliar. We had to adapt to a different culture, a different way of life, and, most importantly, a new language. The language barrier made even simple daily tasks challenging. Every day became an opportunity to learn something new, and every small success felt like a big achievement. Before coming to Canada I had already built a solid career in the information technology industry in Korea. I worked for several IT-related companies, including an Apple reseller, a server company, a distributor of computer peripherals, software, and stor...
Post a Comment
Read more

My YouTube Channel about Digital Technology

I started my career as a ranger instructor before moving to Canada. Since then, I have taught a lot of students who were soldiers, employees, children, or college students from around the world. My students have come from North America, Africa, Asia, and Europe. Even without travelling by myself, I have been able to experience different cultures through my students.  I love teaching, communicating, and troubleshooting.  That's why I started the YouTube channel to help students learn, grow, and succeed. These are the current playlists of my YouTube channel. I'll try to upload as often as possible. If you need any new posts that you are interested in, let me know.  As you can see on the thumbnail, there are six different categories:  Photoshop HTML and CSS Excel Word Illustrator InDesign I'm also planning to add more categories soon, including AI and a career coach.  If you are interested in a specific topic, you can go directly to that playlist to save time. 1. ...
Post a Comment
Read more

Fiction - I Lost My Combat Helmet

In South Korea, virtually all healthy men are required by law to complete mandatory military service, typically between the ages of 18 and 28. Today the term is around 18-21 months, but in the 1990s it was considerably longer—roughly 27 to 30 months, before being gradually shortened in later years. This series is based on my own experience serving during that era. About to receive my permanent base assignment, I still couldn't get the word “soldier” to roll naturally off my tongue. The training uniform didn’t fit my body well, and my combat boots always felt a size too big or too small. To a private second class who had enlisted only a few weeks earlier, the military was still less a “place to live” and more a “place to endure.” Yet the reason I ended up participating in Team Spirit (1988) training was simple. It was because I could speak English better than other Korean soldiers. That was the only reason. Since it was a joint training exercise with the US military, translation ass...
Post a Comment
Read more