All the examples in this article look up values in a formatted Excel table, as structuring data in this way has many benefits. As a result, the formulas use structured table references.

One of XLOOKUP’s key features is its ability to return multiple values from a single formula. This reduces the need for multiple lookup operations, streamlining your workflow and enhancing data ...

Kelly L. Williams, CPA, Ph.D., explains how to use XLOOKUP, a new function for Excel 365 users that essentially replaces VLOOKUP and HLOOKUP.

If you want to look up multiple pieces of information with the same search you can still use an array, but you can retrieve everything with a single lookup rather than needing one for each piece ...

You can use VLOOKUP with Google Sheets similar to how the search function is used to find information in Excel.

TEXTBEFORE and TEXTAFTER are a few more of my favorite Excel functions to clean messy spreadsheets. Excel's newer text ...