No match means the AI looked at the candidates from List B and decided none of them is the same business, organization or person. It is a deliberate answer: the add-in would rather say No match than guess.
Common reasons #
- The partner is not in List B. Often the right answer. Check List B for the name.
- Same name, different place or business. “Smith Plumbing, Houston” is not “Smith Plumbing Inc, Dallas”, and “Kowalski Deli” is not “Kowalski Bakery”. The add-in treats those as different on purpose.
- The ticked columns do not agree. For example, you ticked City and the two lists use different places for the same business, such as a store’s town on a bank line and the head office in your vendor list. Usually just the name is enough. See Choose the columns to compare.
- The right entry was not in the shortlist. When List B has more than 200 entries, the AI chooses among the 20 closest entries by spelling. A complete rename with no shared letters (Facebook and Meta Platforms) can fall outside those 20. After the run, Search thoroughly checks such rows against every List B entry. Names in Cyrillic or Greek are compared in their Latin spelling; for other scripts, such as Japanese, a row that finds no match among the entries it could see gets Review instead of No match. See Work with big lists.
What to do #
- On a List B with more than 200 entries, click Search thoroughly after the run. It asks the AI about every List B entry for the rows without a match, and shows the maximum credits before it starts.
- If you know the partner exists, fix the column choice, or filter List B down to 200 entries or fewer so the AI sees all of them, and run the match again: click Check credits and run, and when the pane says every row already has a result, click Redo all rows. That answers every row again and uses credits again, so for a few rows it is often quicker to fill in the match by hand.
A No match answer is still an answer, so it costs one credit like any other.