Lookup from Companies table back to itself returns no records found for matching values

Ruben K. · 2026-01-22T09:31:14.119Z

Hi folks When performing a Lookup from a People table (generated from a Companies table) back into the same Companies table, column-based lookups return “no record found” for all rows—even when the match values (e.g., Company Name or Domain) are visibly identical in both tables. This occurs regardless of using single-row or multi-row lookup, Equals operator, or verified test cases, suggesting a lookup scoping or field-type mismatch rather than a data-value issue. Tried lookup a single row in another table and it fails see screen recording: https://screen.studio/share/RWsM6fIF I’ve also tried subsequently to do Lookup Multiple Rows in Other Table and it also fails and I don’t get why

Lookup from Companies table back to itself returns no records found for matching values | Clay

Clay Support
APP
·
·
Hi there, thanks so much for sharing this! We’ll be passing your feedback along to our product team, and any additional context you can provide will help us prioritize with your needs in mind as we shape the roadmap.

Want to chat with someone on the team? Feel free to hit the button below!
Clay Support
APP
·
·
Ruben clicked 'Talk with the team!'
Clay Support
APP
·
·
Our support team has got your message and we'll get back to you soon! We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond.

If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

image.png(93 kB)
Ruben K.
·
·
I want to see if someone can help as maybe I’m doing something wrong?
Natalie (.
·
·
Hi Ruben, thanks for reaching out. Do you mind sending the link (url) to the table so we can take a look? The tables may have changed since you reached out, I'm having trouble finding a companies table with a lookup column in your "Outbound" workbook. Thanks!
Ruben K.
·
·
Of course, thanks Natalie (. https://app.clay.com/workspaces/832869/workbooks/wb_0t8wd62C2eFQGoQC6Su/tables/t_0t8wv9n6QCoHUFqfNJf/views/gv_0t8wv9ompqGpiFATC9V
Natalie (.
·
·
Thanks! I created a new column and used "Contains" instead of "Equals" which did the trick. Let me know if you have further questions or need additional help! 😊
Ruben K.
·
·
Oh give me a sec
Ruben K.
·
·
Is that normal though?
Ruben K.
·
·
Equals should be correct no?
Ruben K.
·
·
Also
Ruben K.
·
·
It’s not correct
Ruben K.
·
·
Look at size
Ruben K.
·
·
It’s got a weird hashed number like 12616765-a2cf-4b23-b742-0b9aeae6f34d
Ruben K.
·
·
When the company size clearly exists on the Company Table

30 comments