The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms ...

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.

This newish function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx file .

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations. ... (B2:B5), as shown in the above image.