Lookup multiple rows in other table does not seem to be working correctly: Table: https://app.clay.com/workspaces/12893/workbooks/wb_vAxgTZ4P9wa3/tables/t_BUTjryQWHRRk/views/gv_tE3n5e3cUSA3 Reference I'm looking up:https://app.clay.com/workspaces/12893/tables/t_YG8Sv7GFKuJu/views/gv_PCZ4WPBYcJBB
Without seeing the specific table and reference URLs you're working with, I can provide some general guidance about the lookup functionality:For looking up data across tables, there are two distinct options you should consider:1. "Lookup Multiple Rows" - Use this when you need to find multiple matching records in another table. This is ideal for scenarios where you expect multiple results. 2. "Lookup Single Row" - Use this when you only need to find one matching record. This option offers better performance when you're certain there will be only one match.To help diagnose your specific issue, please share:** The exact matching criteria you're using ** Whether you expect single or multiple matches * Any error messages you're seeingThis will help us better understand and address the problem you're experiencing. Sources: Lookup Multiple Rows in Other Table with Clay Lookup Single Row in Other Table with Clay