Google Sheets lookup column with supporting column

Is there any way to do this, it exists in Zapier!
Basically, I want it to only return the matched value if another value matches too.
kind of like if Name = John Doe & Status = Client
so if there is no john do or if he is not a client it will not return it

Hi @Stuart,

Currently, we don't have this feature available for 'Lookup Spreadsheet' in Pabbly Connect.

However, if you want the next steps of your workflow to be executed only if two conditions are met, you can try adding a Filter to your workflow in this manner.
https://connect.pabbly.com/workflow/share/DUVYalMEUzAHTVQ-BVYAJ1tPAAQHXgJiVUwEFgEOUChXGQJ5B0YPZQhEVXcAR1U0XxZQOlUJUW1bT1BUCV8FdlNKBgQEB1IoVxoEf1YXWmkNU1hwUzI#

Thank you, However the workaround only works if I want it to return one value and filter it out. my real issue is when i have duplicates of the name, but only one is a client (every new appt adds an entry, some people make multiple appts before becoming a client).
I would use a router and filter, but there is no way to 'break' the cycle when I find a match.

Got it! In that case you can submit your request for this feature on our dedicated platform: https://pabbly.featureos.app/b/Update-Existing-Application.

I have added an Iterator to your workflow that should help you achieve a similar result.
https://connect.pabbly.com/workflow/share/DUVYalMEUzAHTVQ-BVYAJ1tPAAQHXgJiVUwEFgEOUChXGQJ5B0YPZQhEVXcAR1U0XxZQOlUJUW1bT1BUCV8FdlNKBgQEB1IoVxoEf1YXWmkNU1hwUzI#

That's pretty disappointing, I see there that someone requested this feature and was turned down.

I am afraid for now that is the only workaround I can suggest for now.