# Need Help writing google sheet formula/glide formula

**URL:** <https://community.glideapps.com/t/need-help-writing-google-sheet-formula-glide-formula/17708>\
**Category:** Ask for Help\
**Created:** [October 28, 2020, 9:40pm UTC](https://community.glideapps.com/t/need-help-writing-google-sheet-formula-glide-formula/17708 "2020-10-28T21:40:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [October 28, 2020, 9:40pm UTC](https://community.glideapps.com/t/need-help-writing-google-sheet-formula-glide-formula/17708/1 "2020-10-28T21:40:20Z")

</div>

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](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/84c0f1e4b01674fdbcdffdd1826f1eff27fb3ecf.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6eb450b7fcd4ba184aa9ac6c259ba9fe0b404a1d.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [October 28, 2020, 11:48pm UTC](https://community.glideapps.com/t/need-help-writing-google-sheet-formula-glide-formula/17708/2 "2020-10-28T23:48:10Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Amal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/amal/32/15421_2.png) [@Amal](https://community.glideapps.com/u/Amal)\
**Post date:** [October 29, 2020, 6:55am UTC](https://community.glideapps.com/t/need-help-writing-google-sheet-formula-glide-formula/17708/3 "2020-10-29T06:55:46Z")

</div>

Amazing, thanks @Jeff_Hager, worked perfectly