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