# How to find matches in 2 columns - LinkedIn Connections **URL:** \ **Category:** Ask the Community\ **Created:** [April 4, 2023, 5:32pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910 "2023-04-04T17:32:52Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Christien\_Louviere](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christien_louviere/32/34008_2.png) [@Christien\_Louviere](https://connect.superhuman.com/u/Christien_Louviere)\ **Post date:** [April 4, 2023, 5:32pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/1 "2023-04-04T17:32:52Z")
Can you help me solve this? [45 second Loom on my work so far](https://loom.com/share/12e17b83b3574da2be4c3751d26ab1a7) ---
**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\ **Post date:** [April 4, 2023, 6:09pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/2 "2023-04-04T18:09:55Z")
Hi Christien, Coda does not understand the “=” in front of the formula. (Green boxes). The message is not the clearest, I admit. Just delete the sign, to get rid of the error message. Second, Matches is used in conjunction with a control. (Red box. ![image](https://global.discourse-cdn.com/coda1/original/3X/e/8/e88370162d897c0024b8d142bff7a96d1de378f6.png) Below is an example of matches in action: It is the formula behind a filter using a canvas control. ![image](https://global.discourse-cdn.com/coda1/original/3X/9/8/98ce6e11df2ce7cc9c3fee3d8edcd3b35f3eaa2b.png) There was a long discussion on doing what you are looking in the last few weeks. I will see if I can find that, if I remember correctly, it was not a trivial exercise. P ---
**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\ **Post date:** [April 4, 2023, 6:19pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/3 "2023-04-04T18:19:40Z")
HI Christien Here is the post I was thinking of: > [@Comparison - Not Contained](https://connect.superhuman.com/t/comparison-not-contained/37892/14): > > Hi Doug, I took a look and think I understand. Would you let me know if [this model doc here](https://coda.io/@billy-jackson/document-comparison) successfully displays the behavior you’re looking for? It has two tables: One, Document Master List is meant to be your “Inventory” that has all the documents already in your system. The Other, Document Intake, is meant to be where you paste in (or somehow generate rows into) all the new documents you need to cross-check against the master list. if the docs in Intake ARE in the master list (in this c… The formula used looks like this: ![image](https://global.discourse-cdn.com/coda1/original/3X/a/1/a16dc0d98adb203390023b89a590f229eb59acc0.png) It might be a little slow, it is going to look, 8000 times, for an entry in a list of 8000 items, so it is 64 million comparisons. If it gives you the results you are looking for, please share the time it takes? Maybe there are ways to speed up the process. Regards Piet ---
**Author:** ![Christien\_Louviere](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/christien_louviere/32/34008_2.png) [@Christien\_Louviere](https://connect.superhuman.com/u/Christien_Louviere)\ **Post date:** [April 4, 2023, 10:08pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/4 "2023-04-04T22:08:57Z")
@Piet_Strydom still working on it; but I just took the “=” out of my formulas, so that fixed a bunch of different things. LOL 🙂 Thank you ---
**Author:** ![Doug\_Loud](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/doug_loud/32/28122_2.png) [@Doug\_Loud](https://connect.superhuman.com/u/Doug_Loud)\ **Post date:** [April 5, 2023, 1:11am UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/5 "2023-04-05T01:11:11Z")
Hi Piet - I’m the DOUG that post really worked for, and I’m grateful to Billy\_Jackson for coming up with it. Had to remember to think in rows instead of cells. ---
**Author:** ![Piet\_Strydom](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/piet_strydom/32/19269_2.png) [@Piet\_Strydom](https://connect.superhuman.com/u/Piet_Strydom)\ **Post date:** [April 5, 2023, 12:36pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/6 "2023-04-05T12:36:59Z")
Yeah, the one thing I could remember was that it was for you… Made it easy to find. 😉 I am just intrigued to see what Coda will do with two lists of 8,000 entries each… ---
**Author:** ![Doug\_Loud](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/doug_loud/32/28122_2.png) [@Doug\_Loud](https://connect.superhuman.com/u/Doug_Loud)\ **Post date:** [April 5, 2023, 7:26pm UTC](https://connect.superhuman.com/t/how-to-find-matches-in-2-columns-linkedin-connections/38910/7 "2023-04-05T19:26:45Z")
Yes, indeed. Maybe a whole different approach like the one the mathematicians use for search?