Failed to Look Up Google Sheets two column's

[Wasaflow]

Hi Comunnity!

I need use Look Up Google Sheets two column's, but don't work, I need A and C column

 

[ArshilAhmad]

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.

 

[Wasaflow]

Hi, I need search by 2 conditions for example Column A = Calzata and Column C = 18324

 

[Preeti Paryani]

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.