But a nice alternative is that it is available in the browser-based Excel with Office online. By contrast, no sorting is necessary with XLOOKUP, and searches default to an exact match.įor now, XLOOKUP is only available in Excel 365, so if you’re using an older version you won’t be able to try out this shiny new functionality. Like its predecessors, XLOOKUP looks for a value in a table and returns a matching result.īut whereas the other lookup functions require complex pairing with other functions like INDEX/MATCH to search in different areas, or IFERROR to display a customized message, XLOOKUP comes with those functionalities built in.Īnd who wants to type two formulas instead of just one?Ī huge game-changer is that VLOOKUP and HLOOKUP formulas assume that you’ll accept near-matches, and that your data is already sorted. The XLOOKUP function in Excel is being hailed as the replacement for both VLOOKUP and HLOOKUP, hence the “X” standing in for either character.
0 Comments
Leave a Reply. |