Need Help writing google sheet formula/glide formula

Ask for Help
1

I have a sheet which has 2 columns one is TID and other is Seed 1 and Seed 2, these need to be checked against another sheet with 2 columns of similar value and return the email address that matches. Please suggest how to do this? If this can we done within glide it will be even better.

Images for ref attached

Capture2
Capture21895×369 60.9 KB
image

2

Would a template column that joins TID and Seed 1 and another template column that joins TID and Seed 2 work for you…then relation columns using the templates, and finally Lookups to get the email?

3

Amazing, thanks @Jeff_Hager, worked perfectly