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.