Return Multiple Rows
I am trying to reference a centralized Goal Document containing the 2021 goals for all our departments. From our Org Sheet, I'd like to reference the Goal Document and return the goals by matching the department name in both sheets. I need it to return multiple rows of goals for each department.
The idea is to have a living Goal document that will update the Org Sheet as goals change.
See my attached Goal and Org photos for reference.
Help Article Resources
Check out the Formula Handbook template!