Skip to main content

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 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.
Table Lookup is found under Enrich → Formulas & Tools. It uses your existing Databar tables as the lookup source.

​
How to use

1

Open the enrichment panel

Click Enrich, then select Formulas & Tools. Choose Table Lookup from the list.
2

Pick a target table

Choose which table in your workspace contains the data you want to pull in.
3

Choose the search column

Select which column in the target table should be searched for matches.
4

Set the match condition

Choose how values should be compared:
  • Contains: partial match (useful for names, domains)
  • Equals: exact match (useful for IDs, emails)
5

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.
6

Get results

The matched result from the target table lands as a new column in your current table.
Table lookup configuration with target table, match condition, and column mapping

​
Use cases

ScenarioHow it helps
Cross-referencing CRM exportsMatch contacts across a marketing list and a CRM export by email
Combining enriched dataPull company details from one enriched table into another by domain
Excluding competitorsLook up a blocklist table and flag matches for removal
Joining datasets on a shared fieldConnect 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.

Enrichments

Learn about all available enrichment options.

Tables overview

Learn how tables work in Databar.