Investigating Lookup Bug Between Table 3 and Table 1

we are performing a "lookup multiple rows in other table" from Table 3 to Table 1 here: https://app.clay.com/workspaces/502615/workbooks/wb_atFzkrA3D4Zh/tables/t_0svfyedkwPEJ884YPSe/views/gv_0svfyed4VVmR7XtsBis I marked a column in red in Table 3 which shows 0 matches - must be a bug as it should be an exact match across at least 100+ rows. Can you please check the bugs & advise how me and Deon M. can fix it?

Channeled
APP
·
·
The "Lookup Multiple Rows in Other Table" action can only use one column at a time to filter and search for matches. To troubleshoot the issue: 1. Verify that you've selected the correct target column in Table 1. 2. Ensure the filter operator is appropriate for your data. 3. Check that the row values in Table 3 exactly match the target column in Table 1. 4. Consider any data formatting differences (e.g., capitalization, spaces). If the problem persists, you may need to review your data for inconsistencies or try using a different column for matching. If you need further assistance, please request human support by clicking on "Talk to a person" in this chat.
Source: Lookup Rows | Documentation | Clay University
Deon M.
·
·
no
Deon M.
·
·
https://app.clay.com/workspaces/502615/workbooks/wb_atFzkrA3D4Zh/tables/t_0svfyedkwPEJ884YPSe/views/gv_0svfyed4VVmR7XtsBis
Tanvi R.
·
·
Hi Tim, thanks for reaching out! It looks like there are at least 115 rows where the lookup has found a match so it looks like this column is working. Let me know if you're seeing anything that should be different.
(79 kB)
Deon M.
·
·
Tanvi R. 🙌
Tanvi R.
·
·
Hey Tim, yes you can! Simply click on a cell that has results from the lookup and you can add each field returned to a new column.
Deon M.
·
·
Tanvi R. Thanks for your assistance. I think I see what’s going on here.