Sunday, June 20, 2021

Use the Excel XLOOKUP Function

The XLOOKUP function is an Office 365 function that is sure to replace the other lookup functions like VLOOKUP, INDEX/MATCH, or HLOOKUP. It's so much more versatile and take the similar argument structure as the other functions and more. You can do various lookup variations like looking up to the left or looking up values from a bottoms up approach...and all this with just one function.

No comments:

Post a Comment