Clay Icon

Troubleshooting Lookup Multiple Rows Function for Accurate Results

Β·
Β·

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

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    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.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·