Two excel sheets - data process and updates

Status: Closed · Asked by rsridhar on · 0 views

rsridhar — Question ·

I have all validated emails in sheet A
I have name, phone and emails in sheet B. Obviously Sheet A emails are a subset of Sheet B email list.

I want to have a logic of comparing sheet A email with Sheet B email, and if present in the right most column in sheet B, insert a word Valid. I can sort and save and import it for my outbound reach.

Can some one help me how I can do this with pabbly connect? Compare the emails in different sheets and mark only matches?

Thanks
Sridhar Rayasam

Fagun Shah — Reply ·

You can use Lookup Row action of Google Sheets in pabbly connect.

But it will maximum return 3 results(from top/botton)

Fagun Shah
- Automation Freelancer
- Let's Connect - https://www.facebook.com/fagun.shah.7/

Back to all forum threads · Log in to reply