> ## Documentation Index
> Fetch the complete documentation index at: https://docs.databar.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Table lookup

> Pull matching values from another table, like VLOOKUP in a spreadsheet.

Table Lookup lets you enrich any table by pulling in matching values from another table in your workspace. Think of it as VLOOKUP built natively into Databar: no formulas, no exports, no manual copy-pasting between sheets.

<Tip>
  Table Lookup is found under **Enrich** → **Formulas & Tools**. It uses your existing Databar tables as the lookup source.
</Tip>

## How to use

<Steps>
  <Step title="Open the enrichment panel">
    Click **Enrich**, then select **Formulas & Tools**. Choose **Table Lookup** from the list.
  </Step>

  <Step title="Pick a target table">
    Choose which table in your workspace contains the data you want to pull in.
  </Step>

  <Step title="Choose the search column">
    Select which column in the target table should be searched for matches.
  </Step>

  <Step title="Set the match condition">
    Choose how values should be compared:

    * **Contains**: partial match (useful for names, domains)
    * **Equals**: exact match (useful for IDs, emails)
  </Step>

  <Step title="Map the lookup value">
    Define which value from your current table to look up. You can use dynamic column references with the `{column_name}` syntax.
  </Step>

  <Step title="Get results">
    The matched result from the target table lands as a new column in your current table.
  </Step>
</Steps>

<Frame>
  <img src="https://mintcdn.com/databar/rot9kxJH78mZvQsF/images/product-guide/table-lookup-configuration.png?fit=max&auto=format&n=rot9kxJH78mZvQsF&q=85&s=c17d9bd9d1b6daafb99db04d3c08d3cc" alt="Table lookup configuration with target table, match condition, and column mapping" width="1516" height="1466" data-path="images/product-guide/table-lookup-configuration.png" />
</Frame>

## Use cases

| Scenario                           | How it helps                                                        |
| ---------------------------------- | ------------------------------------------------------------------- |
| Cross-referencing CRM exports      | Match contacts across a marketing list and a CRM export by email    |
| Combining enriched data            | Pull company details from one enriched table into another by domain |
| Excluding competitors              | Look up a blocklist table and flag matches for removal              |
| Joining datasets on a shared field | Connect any two tables that share a common identifier               |

## Dynamic column references

When mapping the lookup value, use curly braces to reference columns dynamically:

```
{Email}
{Company Domain}
```

This pulls the value from the specified column for each row, just like a formula reference.

## Related

<CardGroup cols={2}>
  <Card title="Enrichments" href="/product-guide/enrichments">
    Learn about all available enrichment options.
  </Card>

  <Card title="Tables overview" href="/product-guide/tables-overview">
    Learn how tables work in Databar.
  </Card>
</CardGroup>