# Introducing xlookup()

DevFeed: [Introducing xlookup()](<https://devfeed.tech/articles/introducing-xlookup-82560.md>)

Original publisher: [Read original article](<https://omni.co/blog/introducing-xlookup>)

Author: Cathy Lennon

Published: 2024-05-31T16:00:00Z

Content type: release

Language: en

Sources: [Omni Blog](<https://devfeed.tech/sources/omni-blog.md>)

Topics: [Product Management](<https://devfeed.tech/topics/product-management.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [semantic-layer](<https://devfeed.tech/topics/semantic-layer.md>)

Tags: [bi](<https://devfeed.tech/tags/bi.md>), [bi-tools](<https://devfeed.tech/tags/bi-tools.md>), [button](<https://devfeed.tech/tags/button.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [data](<https://devfeed.tech/tags/data.md>), [data-modeling](<https://devfeed.tech/tags/data-modeling.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [excel](<https://devfeed.tech/tags/excel.md>), [implementation](<https://devfeed.tech/tags/implementation.md>), [sql](<https://devfeed.tech/tags/sql.md>), [xlookup](<https://devfeed.tech/tags/xlookup.md>)

## AI overview

Omni has launched xlookup(), an Excel-style function for connecting data across queries. It lets users reference fields and perform joins without writing SQL or defining data-model relationships, and can support ad hoc lookups, merging query results, and interactive assumptions.

## Source excerpt

Since we started building Omni, we've focused on designing a product to help everyone achieve their data goals, regardless of their experience with SQL and other BI tools. That's why we're excited to launch support for xlookup(): to give users access to Excel's trusty syntax to connect data across queries.