How to Use XLOOKUP Function in Excel 2019 – A Beginner’s Guide
XLOOKUP is one of the most useful functions available in Excel 365. Unfortunately, XLOOKUP is not available in all other versions of Excel.
It’s a great function to look for items within a column or row. It replaces both VLOOKUP and HLOOKUP but still makes it easier to use than either one!
Follow these steps or refer to the XLOOKUP above for a video walkthrough of this amazing time-saving function.
Example
An XLOOKUP can retrieve data when a match is found. It can return not only one item, but multiple items simultaneously with the following formula: =XLOOKUP(F2,A:A,B:D,”Not Found”,0,1)
- =XLOOKUP: Begin all formulas with an equal sign.
- (F2: lookup_value, what are you going to look up? In this case, “3546”
- A:A: lookup_array, where do you want to find “3546”? In this case, in column A.
- B:D: return_array, if a match is found, what do you want returned? In this case, the data in columns B, C, and D.
- “Not Found”: if_not_found, if a match is not found, what would you like to do? In this case, display the phrase “Not Found”
- 0: match_mode, a zero tells the function to find an exact match
- 1: search_mode, a one tells the function to search from first to last
Please leave a comment if you have any questions! Attached is a spreadsheet with the function in action.
