If a function produces an output, chances are you can pipe that output into another function to accomplish even more. Using Excel creatively is a rewarding, and dare I say fun, experience.

Learn how to use Excel’s XLOOKUP function to simplify data retrieval, save time, and master spreadsheets with this quick ...

With August coming to a close and the summer slowdown reaching its final nadir, it’s hard to focus on deal making right now. You find your mind drifting to the long weekend — nice weather ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...

If you remove the > sign, Excel accepts the function and returns 0 because no value equals the highest commission from last year, $2,710.79. The problem is the comparison operator, >.

Excel’s XLOOKUP() function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx files.