Look for matches in two columns and return list of contents of a third column

[thelittleredfox]

Hi,

I have the following spreadsheet, which lists all payments made under client accounts by date. (Please excuse the horrible layout).

	A	B	C	D	E
1	Row number	Client Name	Payment Date	Payment Amount	True or False
2	2	Dominic Holden	20/04/2018	£6.58	TRUE
3	3	Gary Baines	02/06/2018	£11.22	TRUE
5	5	Teri Kane	05/09/2018	£16.73	FALSE
6	6	Julian Baker	23/09/2018	£9.31	TRUE
7	7	Gillian Houghton	26/09/2018	£8.10	TRUE
8	8	Thomas Hunt	14/10/2018	£7.99	FALSE
9	9	James Clarke	28/10/2018	£2.56	TRUE

<tbody>
</tbody>

The sheet is called "data sheet" and currently has 5000 lines of data, which will probably increase to around 10,000 by the end of the year.

What I would like to do is to create a new tab which lists all records which fall within a specified time period AND where the value in column E is TRUE. There might be multiple results for the same date where column E is TRUE. I'd like it to look something like this:

	A	B	C
1	Client Name	Payment Date	Payment Amount
2	Julian Baker	23/09/2018	£9.31
3	Gillian Houghton	26/09/2018	£8.10
4	James Clarke	28/10/2018	£2.56

<tbody>
</tbody>

I'm guessing I need to use an array formula but I've tried and just can't manage to create one that works. Any help would be appreciated!

 

[KolGuyXcel]

I guess, you are looking for a dynamic range of time period. So you need to be able to provide the range limits "on the go".

Are you looking for a formula or a VBA code?