I have 1 table that has all of the department for expenses with their dollar amounts. I have another table that I want to be able to return all of the dollar amounts for a certain department.
I know that a lookup only returns 1 value, but is there a function that will return all of them?
Thanks.
Have you tried a Pivot Table?
Select the table, then click the Pivot Table icon in the bar above the page, then click to check the boxes beside the Field names in the right sidebar.
Those two clicks will immediately produce the Pivot Table shown below:
Quick and easy, and worth further exploration.
Regards,
Barry
jay-dd wrote:
another table that I want to be able to return all of the dollar amounts for a certain department.
Keep in mind that if you want to list all of the dollar amounts for a certain department you can also simply filter on that column in the original table, and turn off the filter when you are done. If you really need those amounts in a separate table, instead of in the original table filtered, you can select the cells visible after applying the filter, command-c to copy, click once in a cell of an existing destination table, and Edit > Paste Formula Results.
If you go the Pivot Table route, which has lots of advantages, you can also obtain a filtered list by clicking the relevant cell in the Pivot Table and choosing from the menu Organize > Create Table for Source Data.
SG
How to return numbers only if they match the same Department
