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

VLOOKUP and Search are two functions that Excel uses to search for text. VLOOKUP finds data in a column and returns the contents of an adjacent cell.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

A combo box's autocomplete feature linked to a lookup function creates a flexible search tool.

Excel tables help manage dynamic data ranges, adjusting automatically as data changes. The function helper in Excel provides a step-by-step guide to entering VLOOKUP arguments.