Two excel sheets - data process and updates

[rsridhar]

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]

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

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