Troubleshooting Lookup Multiple Rows Function for Accurate Results

Justin Tung · 2025-03-26 23:31:01.910056+00

My Lookup multiple Rows function is returning bogus results even though Im asking it to Equal (exact) a field.

The Lookup Multiple Rows function is designed to filter based on a single column at a time. If you're getting unexpected results, it might be because you can only use one column for filtering, even when using the Equal (exact) condition. To use this function effectively: 1. Choose the table to search 2. Select a single target column 3. Set the filter operator (in your case, Equal (exact)) 4. Provide the row value to match If you need more specific help, please share more details about your setup or the exact results you're seeing.

Source: Lookup Rows | Documentation | Clay University

2 comments