Reference to Multiple Rows
I have a sheet containing many invoices and each having a particular expense category.
In another sheet I have a Work Breakdown Structure with these expense categories. In one column I get total of each expense categories invoices by SUMIF function but I want to access all the invoices that makes up this sum from the WBS sheet item details. Like maybe in one column I see all the invoices list that corresponds to this expense category.
Is it possible?
Help Article Resources
Check out the Formula Handbook template!