There are many ways to find and retrieve data from a table or range based on a lookup value. In fact, because Microsoft often comes up with new, modernized alternatives, there are too many ways! So, ...

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 ...

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.

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 ...