Forum Discussion
Populating a table based on data in another table
Hi, I'm creating a personal budget sheet where i have one tab that tracks all transactions (example entries below). This tab will have ALL transactions. I'd like to have a summary tab where I ...
Let's say the budget data are in B3:E1000 on a sheet named Budget Sheet.
On the Summary sheet, the year is in B4 and the month is in D4.
The following formula returns the filtered data:
=FILTER('Budget Sheet'!B3:E1000, TEXT('Budget Sheet'!B3:B1000, "mmmmyyyy")=D4&B4, "No Match")