Failed to Look Up Google Sheets two column's

Status: Open · Asked by Wasaflow on · 0 views

Wasaflow — Question ·

Hi Comunnity!

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

Attachments

Screen Shot 2024-10-06 at 14.28.27.png
Arshil Ahmad — Reply ·

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 — Reply ·

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

Preeti Paryani — Reply ·

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.

Thanks & Regards,
Preeti Paryani
Customer Support Associate
Pabbly.com

Back to all forum threads · Log in to reply