Learn how to use the XLOOKUP function in Google Sheets to search for values. No more VLOOKUP!
Often when working with spreadsheets you need to find a specific data point for a certain set up data. For this we tend to use the VLOOKUP formula. However, the XLOOKUP is an improved version of this. It is versatile and easy to use!
The XLOOKUP Formula in Short
The XLOOKUP is a function in both Google Sheets and Microsoft Excel. It requires three main components:
What you are searching for
A lookup array
A result array
Using the XLOOKUP Function in Google Sheets
For example, you might want to find the country of some of the people that have won the Noble Peace price (using this data source).
We are interested in finding the country of the 7 people in the image below.
In this case, you can utilize the XLOOKUP formula to easily find and return the data.
See how it can be done in the video below.
Try it yourself now!
Click here to copy paste the Google Sheet spreadsheet in the video.
コメント