Look up in another list, and the List role
Every list in your workspace can be looked up in from your other lists and pipelines. "Is this contact in my customer list?", "is this company in the competitors list?" — that works with any list, on Basic and Pro alike, without turning anything on first. On top of that you can give a list a List role (customers, competitors, partners, block, or a name of your own); the role decides which lists ListPlus consults by itself, for badges, the "Already known" check and blocking.
Where you can ask "is it in another list?"#
- List triggers and a pipeline's Data check: the condition group Lists offers every list of the workspace — pick the list by name as the field, then is in it or is not in it. "Only hand over to HubSpot if the company is not in it [Existing customers]" keeps current customers out of outreach.
- Score and Assign (label) columns: the same "is in it / is not in it" rule as a criterion (see "Scoring a list and labeling records by rules").
- + Column → In list: a column that shows Yes or No for every row. It follows the other list: when a record is added there or removed, the column updates by itself. It uses no credits.
- + Column → Value from list: takes a value from the matching row of the other list, or counts the matches (see below).
In every picker, the lists with a role come first, then all other lists by name. A column never looks into its own list.
How matching works#
Matching is exact, never fuzzy, and never by name. It happens on one of two levels:
- Company — a contact counts as "in the list" when their company
domain, website, or the domain of their work email is in it. A colleague
at the same company counts too, and a domain also covers its subdomains
(listing
acme.comalso matcheseu.acme.com). Personal email addresses (Gmail, Yahoo and similar free providers) never count on company level, and neither do platform addresses: a website or domain on linkedin.com, facebook.com, x.com, twitter.com, instagram.com, xing.com, youtube.com, google.com, github.com or medium.com is ignored, so a LinkedIn company page in a website column never makes "linkedin.com" a customer. - Person — only the same individual counts: the same email address or the same LinkedIn profile URL.
Which level a list is matched on:
- A list with a role uses the level its role sets (Set up → List role → Match by).
- Any other list follows its kind: a company list is matched on company level, a contact list on person level.
Rows marked ignored in the other list are left out. After the other list changes — rows added, edited or ignored — it can take up to about a minute until conditions and badges reflect it; there is nothing to refresh by hand.
The "Value from list" column#
+ Column → Compare → Value from list puts a value from another list beside your rows — the account owner or customer status from your company list into a contact list, for example. You choose:
- List — any other list of the workspace.
- Match by — Domain, Email or LinkedIn. It starts on Domain for a company list and on Email for a contact list; you can change it. Domain matching works as on company level above (website and work email domain included, subdomains under their parent).
- What the column shows — one of that list's columns, or Number of matches (how many of its rows match).
- Column name.
The column fills once when you create it, and again every time you click Run in its header. It never fills by itself: when either list changes, the column keeps its values until the next Run. Its cells can't be edited by hand.
- Price: credits per row of your list on every Run, charged after the run — the Run button's tooltip shows the price, and "Price list: what every action costs" has the rate. If your balance doesn't cover a Run, the column pauses and says so.
- Several matching rows: the first row in the other list's order that has a value wins. A row without a match stays empty (with Number of matches: 0).
- The other list was deleted: the next Run empties the column and its header says "The list this column reads from no longer exists." Nothing is charged for that Run.
This column replaces the old "Take data from another list" wizard. The entries Value from another list... (list menu), Take values from another list (Enrich menu) and Take a value from another list (command bar) now open + Column on Value from list.
The List role (optional)#
Open the list, click the Set up icon next to the list's name (or ⋯ menu → List Settings...), go to List role, and turn on Set a role. Choose what the list holds — Existing customers, Competitors, Partners, Block (never send on), or Something else (give it a name, e.g. "Investors") — and Match by: Company (domain) or Person (email, LinkedIn). Click Save. Roles work on every plan.
Only the workspace owner and admins can set or change a role, because it changes what every pipeline in the workspace does; other members see the setting but can't edit it.
The role does not decide whether a list can be used in conditions or columns — every list can. It only decides which lists ListPlus consults by itself:
- Badges — a small colored badge (Customer, Competitor, Partner, Blocked, or your own name for a "Something else" list — "Listed" if you didn't give one) appears on a contact wherever you look it up: on hits in AI Research, on results and candidates in Person Search and the Inbox, in the contact detail panel, and in the row on the Watchlist page. Hover it to see "In the list 'X'". It does not appear inside a list's own grid or on Segment Search results — add an In list column for that.
- The "Already known" check in a list's Analyze panel flags rows that are in a list with the role customers, competitors, partners or your own role (not block).
- Blocking — see below.
The "Block" role#
A list with the role Block behaves exactly like your workspace's Block list (Settings → Block list): a pipeline sending to an external target — your CRM, Slack, a webhook, a sequencer — skips any matching contact automatically, and the "On the block list" check in a list's Analyze panel flags matching rows. You don't need to also add those contacts to the Block list by hand. Blocking uses email addresses and domains: on person level a Block list blocks by email address (a LinkedIn URL alone doesn't block). See "Block List and the do-not-contact check" for how that enforcement works in detail.
Read-only when it refreshes from its source#
A list with a role that also has Refresh automatically set to Daily or Weekly (Set up → Refresh automatically, for lists from HubSpot, Salesforce and other connected sources) becomes read-only for its record data: the source is the truth, and the next refresh would overwrite any change made here anyway. The list shows a banner: "This list comes from HubSpot and is refreshed daily – change records there. As a list with a role it is read-only here." (with your source and schedule).
While it's locked you can't edit cells, add or delete rows, enrich, run AI columns, or let a pipeline add records to it or enrich them. It can't have a list webhook either ("This list is refreshed from its source and takes no data here."). What stays possible: setting a status, adding or removing tags, creating sublists, and ignoring rows — those belong to ListPlus, not to the source. Set up stays editable too: set Refresh automatically to Off, or turn off Set a role, and the list can be edited again. A list without a role is never locked this way, and a refresh that is paused after failed attempts doesn't lock the list either.
For advanced users#
"Is in it" runs off an index of exact keys (domain, email, LinkedIn URL) built from the other list's rows when it is first needed. It's rebuilt after the list changes, at most once a minute, and it's dropped an hour after it was built (the next question builds it again). If the other list can't be read at that moment, a condition answers "unknown" — never "not in it": a pipeline holds the records ("Another list could not be checked — held") rather than letting customers through or a block list stop blocking. The live preview while editing a trigger leaves conditions on other lists out of its count and says so ("Other lists are checked when the trigger runs — the preview leaves those conditions out."); the trigger itself checks them every time it runs.
Related topics: columns-formulas-ai-columns · scores-and-assigned-columns · list-triggers · pipeline-data-check · do-not-contact-and-block-list · list-settings · roles-and-permissions.
FAQ#
Can I check whether a contact is in another list?#
Yes — with any list of your workspace, on every plan. In list triggers and pipeline data checks pick the list in the condition group "Lists" with "is in it" or "is not in it"; in Score and Assign columns use the same rule; or add an "In list" column (Yes/No) or a "Value from list" column via + Column.
What happened to reference lists?#
There is no "turn this list into a reference list" setting any more: every list can be looked up in, without a plan. What remains is the optional List role (Set up → List role), which decides which lists give badges, feed the "Already known" check and block deliveries.
How do I give a list a role?#
Open the list → Set up → List role, turn on Set a role, pick what it holds (Existing customers, Competitors, Partners, Block, or Something else with a name) and Match by (Company or Person), then click Save. Only the workspace owner and admins can set or change it.
How does company-level matching work?#
A contact counts as "in the list" when their company domain, website, or work email's domain matches a domain in the other list — a colleague at the same company counts too, and a listed domain also covers its subdomains. Personal email addresses (Gmail, Yahoo, etc.) never count on company level, and matching is never by company name.
How does person-level matching work?#
Only the exact same person counts: the same email address, or the same LinkedIn profile URL. Two different people at the same company do not match each other on person level.
Which level is a list matched on?#
A list with a role uses the level its role sets (Match by). Any other list follows its kind: a company list is matched by company (domain, website, work email domain), a contact list by person (email, LinkedIn).
Where do I see that a contact is a customer, competitor, or partner?#
Only lists with a role give badges: on hits in AI Research, on results and candidates in Person Search and the Inbox, in the contact detail panel, and in the Watchlist page's table. Inside a list's own grid, add an "In list" column instead.
Can I use another list in a pipeline's data check or a list trigger?#
Yes — every list of the workspace appears in the condition group "Lists", with the operators "is in it" and "is not in it". The lists with a role come first, then all others by name.
How do I bring a value over from another list (like VLOOKUP)?#
Add a column with + Column → Value from list: pick the list, match by Domain, Email or LinkedIn, and choose one of its columns or Number of matches. It fills when created and on every Run in its header, costs credits per row on every Run; it never updates by itself.
Why does the trigger preview leave other lists out?#
The live count you see while editing a trigger's conditions skips conditions on other lists to keep the preview fast; the trigger itself still checks them correctly every time it actually runs.
What does the role "Block" do?#
It behaves exactly like your workspace's Block list: pipelines never hand a matching contact to an external target (CRM, Slack, a webhook), and the "On the block list" check flags it in a list. You don't need to copy those contacts into the Block list separately.
Can several lists have the same role?#
Yes — any number of lists can have a role, including several with the same one (e.g. two separate "Competitors" lists), and each gives its own badges and counts in the checks.
Can I still edit a list with a role, or why is it read-only?#
A list with a role is an ordinary list you can edit, enrich and import into — unless it also refreshes automatically from its source (HubSpot, Salesforce …): then its record data is read-only, so change records in the source. Statuses, tags and ignoring rows still work; setting Refresh automatically to Off or turning off Set a role unlocks it.
Which plan do I need?#
None in particular. Looking up in other lists, the In list column, the Value from list column and List roles work on Basic and Pro alike. Only Value from list costs credits, per row on every Run.
I changed the other list — why don't conditions and badges show it yet?#
A change to the other list (rows added, edited or ignored, or a new role) can take up to about a minute to show in conditions and badges. If a badge already on screen still looks old after that, reload the page. A Value from list column only changes on its next Run.
Why doesn't a LinkedIn or Facebook URL match on company level?#
Platform addresses never count as a company: a website or domain on linkedin.com, facebook.com, x.com, twitter.com, instagram.com, xing.com, youtube.com, google.com, github.com or medium.com is ignored. Otherwise a LinkedIn company page in a website column would make every LinkedIn link match; add the company's own domain instead.