Two excel sheets - data process and updates
Status: Closed · Asked by rsridhar on · 0 views
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
You can use Lookup Row action of Google Sheets in pabbly connect.
But it will maximum return 3 results(from top/botton)