Issue with Lookup Not Returning Records in Row Values

I did a lookup and inserted to columns in row value. And I know that there is a value for the second row value column that I inserted, but it showed no records found

3 comments

Channeled
APP
·
·
There could be a few reasons why your lookup isn't finding the expected value. Here are some things to check: 1. Verify the lookup column and value are correct. 2. Ensure the data type matches (e.g., text vs. number). 3. Check for extra spaces or formatting issues in the lookup value. 4. Confirm you're searching the right table or sheet. If you've double-checked these and still have issues, you might need more detailed troubleshooting. In that case, please request human assistance by clicking on "Talk to a person" for further help with your specific setup.
Sources: Lookup Rows | Documentation | Clay University Google Sheets integration overview | Documentation | Clay University
David
·
·
https://app.clay.com/workspaces/504137/workbooks/wb_0svl8u9sFWRAainMy8d/tables/t_0svl9dcXh8NThtCV2kp/views/gv_0svl9ddq6z9kPAJZjP9
Owen C.
·
·
Hey David, thanks for reaching out! The reason why this is happening is because both columns contain data which is conglomerating into a value like what's shown below: "PICCASO (Privacy, InfoSec, Compliance, Culture, Awareness, Strategy, Ops)PICCASO (Privacy, InfoSec, Compliance, Culture, Awareness, Strategy, Ops)" Since this is the value being used to lookup agains the "Name" column in the other table, and your filter operator is "equals" there will not be a match. Even if this filter operator is contains, I would recommend sending this through some sort of Normalization column (which is free ;) as shown below in both tables to make sure this data is super clean. Let me know if this helps!
(204 kB)
(204 kB)
(89 kB)