FILTER FUNCTION WITH DROP DOWN

[datastudent]

Hi,

So I have these data in in the first table, "Table3", and I want to filter them onto my second table according to the filter on my drop down(MONTH AND YEAR).
Here's the formula I tried but is not working =FILTER(Table3(Table3[MONTH]=$J$1)*(Table3[YEAR]=$L$1),"").

Income & Expense Tracker.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	MONTH	YEAR	DATE	TYPE	CATEGORY	AMOUNT	DESCRIPTION		MONTH	February	YEAR	2024
2	February	2024	2/29/2024	IN	CASH	₱1.00
3	March	2024	3/4/2024	IN	GCASH	₱2.00			MONTH	YEAR	DATE	TYPE	CATEGORY	AMOUNT	DESCRIPTION
4	March	2024	3/4/2024	OUT	CASH	₱3.00			#VALUE!
5	March	2024	3/4/2024	OUT	GCASH	₱3.00			#VALUE!
Sheet1

Cell Formulas
Range	Formula
I4:I5	I4	=FILTER(Table3(Table3[MONTH]=$J$1)*(Table3[YEAR]=$L$1),"")

Cells with Data Validation
Cell	Allow	Criteria
L1	List	=#REF!
J1	List	=Pivot!$A$1:$A$5

 

[Eric W]

Try:

=FILTER(Table3,(Table3[MONTH]=J1)*(Table3[YEAR]=L1))

Also note that spill formulas don't work in Excel tables, so you can just spill the results onto an empty section of sheet, and use Conditional Formatting to make it look like a table.

 

[datastudent]

@Eric W Thank you so much. I didn't know about the spill formula not working in excel tables. I really appreciate the information