Updated: Sep 13, 2022
Discover how the XLOOKUP can help solve your Excel lookup problems by watching this short video: How to use Excel XLOOKUP in 2 minutes!
What is Excel XLOOKUP?
The XLOOKUP function enables you to find things in an Excel table or range by row, for example, look up the employee job role using their email address, or find an employee name based on their employee ID.
With XLOOKUP, you can look in one column for a search term and return a result from the same row in another column, regardless of which side the return column is on.
Remember all those times your VLOOKUP didn't work?! The XLOOKUP function is a lot easier to use and more flexible!
Watch this video to learn more: How to use Excel XLOOKUP in 2 minutes!