Relations

Ask for Help
1

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.

2

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.

3

Thank you.

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

Thanks again.

4

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.