# Relations

**URL:** <https://community.glideapps.com/t/relations/899>\
**Category:** Ask for Help\
**Created:** [October 4, 2019, 10:27pm UTC](https://community.glideapps.com/t/relations/899 "2019-10-04T22:27:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Makis\_Theonas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makis_theonas/32/713_2.png) [@Makis\_Theonas](https://community.glideapps.com/u/Makis_Theonas)\
**Post date:** [October 4, 2019, 10:27pm UTC](https://community.glideapps.com/t/relations/899/1 "2019-10-04T22:27:03Z")

</div>

I have 2 sheets, as follows:  
**Services**  
SERVICEDESC MANAGER SERVICEIMAGE  
Service1 ManagerX Image1  
Service2 ManagerY Image2  
Service3 ManagerZ Image3

**Schedule**  
DATE SERVICE EMPLOYEE  
Date1 Service1 Employee1  
Date2 Service1 Employee2  
Date3 Service2 Employee3

How can I display the SERVICEIMAGE in the layout of tab SCHEDULE? I have created the relation SCHEDULE.SERVICE → SERVICES.SERVICEDESC.

Thank you.

---

<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 4, 2019, 10:57pm UTC](https://community.glideapps.com/t/relations/899/2 "2019-10-04T22:57:51Z")

</div>

You will need to create an Image column in your Schedule sheet. Then add this formula in the second row of that new column

`=arrayformula(IF(LEN(A2:A) = 0, "", VLOOKUP(B2:B, Services!A2:C, 3, false)))`

This does a lookup of the service name (B2:B) in the Services sheet and returns the 3rd column that it finds (ServiceImage). Then you can add the image component in your schedule tab.

---

<div class="post-metadata">

**Author:** ![Makis\_Theonas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/makis_theonas/32/713_2.png) [@Makis\_Theonas](https://community.glideapps.com/u/Makis_Theonas)\
**Post date:** [October 4, 2019, 11:03pm UTC](https://community.glideapps.com/t/relations/899/3 "2019-10-04T23:03:14Z")

</div>

Thank you.

I thought there might be another way to “reference” the image without copying it with arrayformula and vlookup.

Thanks again.

---

<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 4, 2019, 11:06pm UTC](https://community.glideapps.com/t/relations/899/4 "2019-10-04T23:06:38Z")

</div>

No problem. I don’t believe there is a way to carry column values from a higher level down to the detail level. I’ve heard rumors of a LOOKUP option in the future that might work, but it’s not available at this time.