XLookup to omit filtered data

[wizardmagu]

Just curious if anyone has some ideas to use an XLOOKUP or VLOOKUP and have it omit the filtered data. I am not trying to sum anything just looking to pull information from another sheet.

 

[JamesCanale]

MrExcelPlayground16.xlsx
	D	E	F
1	Thing	Amount	Filtered?
3	B	4	1
4	C	5	1
5	B	6	1
6	C	7	1
7	F	8	1
8	D	5	1
9	E	6	1
10	F	7	1
11	A	4	1
13	C	5	1
14	F	9	1
15	E	6	1
16	A	4	1
18
19	A
20	4
Sheet3

Cell Formulas
Range	Formula
F3:F11,F13:F16	F3	=AGGREGATE(3,5,[@Thing])
D20	D20	=XLOOKUP(D19&1,Table1[Thing]&Table1[Filtered?],Table1[Amount],"",0)