Hi ! I’m having an issue with the Single Row Lookup: it doesn’t retrieve a column from another workbook. I’m trying to fetch a text value that exists on all rows of that column. Even when I try to use a formula, it doesn’t work. Do you have any idea what could be causing this?
A few things could be causing your Single Row Lookup issue:
Check your match key setup:
- Make sure you have a shared value between both tables to match on (like company URL, email, etc.)
- Clean and normalize both sides - trim whitespace, use consistent formatting, lowercase if needed
- Use stable, unique identifiers rather than company names when possible [1]
Verify your configuration:
- Table to search: correct target table
- Target column: the column you're matching against
- Filter operator: try "Equals" for exact matches or "Contains" for flexible matching
- Row value: the value you're looking for [2]
Remember the limitation:
You can only filter on one column at a time with lookup actions - you can't use multiple columns as filters
If you're still stuck, try our built-in AI tool Sculptor in the top-right corner - it can help troubleshoot table setups and workflows. Let me know if Sculptor helps or if you need more specific guidance!
Is that what you were looking for?
If you still need help resolving the Single Row Lookup issue, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific errors you’re encountering?
The lookup is working, since I’m able to retrieve information from all the other columns except the one I’m interested in. I can’t find the name of the column I’m looking for. I need more precise guidance.
If you can't find the column name you're looking for in the dropdown, it might be because:
The column doesn't contain data - Clay only shows columns that have been populated with data. If the target column is empty across all rows, it won't appear in the dropdown. [1]
The column name might be different than expected - Check the actual column headers in your target table to confirm the exact name.
Try this: Go directly to your target table and verify:
- The column exists and has data
- The exact column name (including any spaces or special characters)
- That at least some rows have values in that column
If you're still having trouble, try our Sculptor tool in the top-right corner - it can help troubleshoot table setups and guide you through the lookup configuration. Let me know if Sculptor helps or if you need more specific guidance! [2]
Did that answer your question?
The column is properly filled and has the correct name. The Sculptor tool doesn’t work in this case because the data is coming from two different workbooks.
Ah, that explains it! Sculptor has limitations with cross-workbook operations - it can't handle advanced linking and workflows between different workbooks yet. [1]
For Single Row Lookup across workbooks, there's a maximum of 20 tables that can be connected, including tables across workbooks. [2]
Try this: Double-check that your target workbook/table is properly accessible from your current workspace. Sometimes column visibility issues occur when tables are in different workbooks.
If the column still won't appear in the dropdown, you might need to ask for human help since cross-workbook lookups can have specific permission or connectivity requirements that need manual troubleshooting.
Was this helpful?
I made a mistake — it’s in the same workbook, but in a different table.
Got it! Since it's within the same workbook but different table, the column should definitely appear in your dropdown if it has data. [1]
Quick check: Make sure the target column actually contains data - Clay only shows columns that have been populated. Empty columns won't appear in the dropdown.
If the column has data but still isn't showing up, try refreshing your lookup configuration or double-check you're selecting the right target table in the "Table to search" field. [2]
Is that what you were looking for?
If you still need help with your Single Row Lookup issue, I’m here to assist. Would you like to provide more details about the specific table or column you’re trying to access so we can continue troubleshooting?
I’ve tried doing that, but it still doesn’t work. I wan contact the human support
I understand your frustration, and I’ll connect you to a human agent who can assist you further.
