• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Failed to Look Up Google Sheets two column's

Wasaflow

Member
Hi Comunnity!

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

Screen Shot 2024-10-06 at 16.16.45.png
 

Attachments

  • Screen Shot 2024-10-06 at 14.28.27.png
    Screen Shot 2024-10-06 at 14.28.27.png
    137 KB · Views: 11

ArshilAhmad

Moderator
Staff member
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.
1728256887263.png
 

Preeti Paryani

Well-known member
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.

Calzata-Wasaflow-Curpus-post-orden-Pabbly-Connect-10-07-2024_11_07_AM (1).png


Calzata-Wasaflow-Curpus-post-orden-Pabbly-Connect-10-07-2024_11_07_AM (2).png


Calzata-Wasaflow-Curpus-post-orden-Pabbly-Connect-10-07-2024_11_07_AM (3).png


Calzata-Wasaflow-Curpus-post-orden-Pabbly-Connect-10-07-2024_11_07_AM.png
 
Top