Failed to Look Up Google Sheets two column's
Status: Open · Asked by Wasaflow on · 0 views
Hi Comunnity!
I need use Look Up Google Sheets two column's, but don't work, I need A and C column

Attachments

Hi @Wasaflow,
You cannot search for a value in two columns within the same 'Lookup Spreadsheet Rows' action step. You will need to add two separate 'Lookup Spreadsheet Rows' action steps to your workflow and search for a value in different columns in each step.
Hi, I need search by 2 conditions for example Column A = Calzata and Column C = 18324
Hello @Wasaflow
Yes you can search by 2 conditions for that you will have to add two Lookup Spreadsheet actions for each of the condition and then you would have to add a filter after it to filter the responses based on both conditions. Please refer to the attached images for info.



