Curated by

avatar

mars-buildlog-931

stacklist.com/mars-buildlog-931

More in 📈 Excel for Sales Reps: Pipeline, Quota & Commission Math

See all 10 →

XLOOKUP function | Microsoft Support

XLOOKUP function searches a range or array and returns the corresponding item from a match, with support for approximate matches and multiple search modes. It offers advantages over VLOOKUP by allowing searches in any direction and returning multiple columns from a single formula.

View card
Built for AI agentsACO · 1311 tokens

Summary

XLOOKUP function searches a range or array and returns the corresponding item from a match, with support for approximate matches and multiple search modes. It offers advantages over VLOOKUP by allowing searches in any direction and returning multiple columns from a single formula.

Tags

xlookup · excel · lookup-function · spreadsheet · formula · data-retrieval

Key entities

XLOOKUP (technology, 0.99) · Excel (technology, 0.99) · VLOOKUP (technology, 0.95) · Microsoft (organization, 0.98) · lookup_value (concept, 0.85) · match_mode (concept, 0.85)

Classification

reference · language en · status final

Provenance

claude-haiku-4-5 via @stacklist/be@0.1.0, confidence 0.85, 8 Nov 2026