Reverse VLOOKUP? INDEX - MATCH?

[AYouQueTai]

Hello,
I'm looking for a formula that would accomplish the following.
If the date in worksheet (DRP Payable "J") is between the start (A3)and end date (D3) of the pay period listed in (Pay Period Report), I would like to list the results of J,G and H from DRP Payable to be listed in Pay Period Report cells A,C,E. The problem is that I dont know how many rows I will have on any given pay period. How would I accomplish this with a formula instead of a Macro that filters the data?


Thanks

 

[AhoyNC]

Maybe something like this. Copy formulas down as needed.

Excel Workbook
	A	B	C	D	E	F	G	H	I
1							DRP PRO	DRP$	Billed
2	Start			END			23578	400	1/12/2019
3	12/30/2018			1/26/2019			23578	425	1/15/2019
4							23578	450	2/6/2019
5		Dray Pro	Charges				23578	475	5/15/2019
6		23578	400				23579	500	1/2/2019
7		23578	425				23530	525	2/26/2019
8		23579	500				23530	550	1/18/2019
9		23530	550				23530	575	1/12/2019
10		23530	575				26888	600	5/6/2019
11
Sheet

 

[AYouQueTai]

That is awesome. Thank you so much.

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.