Lijsten & Outreach

List Lookup

Match an account in another Bigmind list and return selected fields from its row.

A List Lookup column finds the same account in another Bigmind list and returns selected fields from the matching row. Use it to reuse prepared account data without copying and maintaining it manually in every list.

#Before you start

Both lists need a Targetable Account column. List Lookup compares those account identities to find matching rows.

#Add a List Lookup column

  1. Add a column and choose List Lookup.
  2. Under Match from this list, select the current list's Targetable Account column.
  3. Under Look in list, select the source list.
  4. Under Match against column, select the source list's Targetable Account column.
  5. Under Return fields, choose the source-list columns you want returned.
  6. Optionally add run conditions or transform the output.
  7. Create the column and run a cell, row, or column.

#Result structure

The result contains the total match count and a records array. Each record includes the matched row ID, its Targetable Account value, and the fields selected under Return fields. A downstream Formula, AI, or enrichment input can read this structured result.

#Example

Suppose a master account list contains Account tier, Owner, and Latest research. In a campaign-specific list, add a List Lookup column that matches Account to the master list and returns those three fields. The campaign list can then use the returned values while the master list remains the maintained source.

#Run conditions and output transforms

  • Run conditions: Skip lookup work for rows that should not be processed, such as rows without a usable account value.
  • Transform output: Reshape the lookup result with JavaScript after it runs. The expression can read the lookup result as value, along with columns and variables.

#Troubleshooting

  • No current account column is available: Add a Targetable Account column to the current list first.
  • No source account column is available: Confirm the selected source list also has a Targetable Account column.
  • No result is returned: Check that both rows use the same account identity type and lookup value, preferably the same normalized domain.
  • A field is missing: Edit the List Lookup column and select it under Return fields.
  • Several matches are returned: Review duplicate accounts in the source list and enable unique domains on its Targetable Account column when the list should contain one row per account.
Updated 8/4/2026