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.
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?
