🔎XLOOKUP is Excel's best and easiest function for solving LOOKUP problems.
💼XLOOKUP can be used to find divisions and bonus schemes based on employees' yearly salaries.
🔄Unlike VLOOKUP, XLOOKUP can search for values from either side and return the last match.
➡️XLOOKUP can handle horizontal LOOKUPs, eliminating the need for HLOOKUP.
🔒XLOOKUP is currently only available for Office 365 insiders, but will soon be available for all Excel for Office 365 users.
What is XLOOKUP?
—XLOOKUP is a function in Excel that allows you to look up and retrieve values from a specified range.
How is XLOOKUP different from VLOOKUP?
—XLOOKUP offers advantages over VLOOKUP, such as the ability to search for values from either side, return the last match, and handle horizontal LOOKUPs.
Can XLOOKUP be used for horizontal LOOKUPs?
—Yes, XLOOKUP can handle both vertical and horizontal LOOKUPs, eliminating the need for HLOOKUP.
Is XLOOKUP available in all versions of Excel?
—No, XLOOKUP is currently only available for Office 365 insiders, but will soon be available for all Excel for Office 365 users.
What are some advantages of using XLOOKUP?
—Some advantages of using XLOOKUP include the ability to search for values from either side, return the last match, and handle both vertical and horizontal LOOKUPs.
00:00In this video, we learn about Excel's best and easiest LOOKUP function: XLOOKUP.
01:56To find divisions and bonus schemes for project team members based on their yearly salary using XLOOKUP, start with the LOOKUP value and LOOKUP array.
04:41XLOOKUP can also be used to calculate the bonus percentage based on the salary.
05:38XLOOKUP offers advantages over VLOOKUP, such as the ability to search for values from either side, return the last match, and handle horizontal LOOKUPs.
06:29XLOOKUP is currently only available for Office 365 insiders, but will soon be available for all Excel for Office 365 users.
