Populate Data Based on Start and End Date

[kumara_faith]

Hi

I have the following table:

Book1
	C	D	E	F	G	H	I	J
2	Table 1			Table 2			Table 3
3	Date	Price		Start Date	7/6/2012		Date	Price
4	2/11/2010	1.405625		End Date	13/2/2013		7/6/2012	1.9125
5	3/11/2010	1.425938					8/6/2012	1.96875
6	4/11/2010	1.476458					11/6/2012	1.874583
7	5/11/2010	1.478229					12/6/2012	1.93375
8	7/10/2011	1.336042					13/6/2012	1.895833
9	10/10/2011	1.473125					6/2/2013	2.354167
10	11/10/2011	1.504583					7/2/2013	2.36
11	7/6/2012	1.9125					8/2/2013	2.431667
12	8/6/2012	1.96875					11/2/2013	2.430833
13	11/6/2012	1.874583					12/2/2013	2.4025
14	12/6/2012	1.93375					13/2/2013	2.430417
15	13/6/2012	1.895833
16	6/2/2013	2.354167
17	7/2/2013	2.36
18	8/2/2013	2.431667
19	11/2/2013	2.430833
20	12/2/2013	2.4025
21	13/2/2013	2.430417
22	14/2/2013	2.425417
23	15/2/2013	2.404583
24	19/2/2013	2.457083
25	20/2/2013	2.345
26	21/2/2013	2.26875
Sheet1

Table 1 is the data table

Table 2 is the dates for selection.

In Table 3, I am trying to populate only the dates and prices based on the selection in Table 2. I am able to use xlookup for the first date to populate but I am not sure how to continue to populate for the rest of the dates and price.

=XLOOKUP(G3,C4:C26,C4:C26)

The expected results is in Table 3

Appreciate all the help. Thank you in advance

 

[navic]

Try the ARRAY formula in the 'I4' cell (copy down)

=IF(ROWS($4:4)<=SUM(($C$4:$C$22>=$G$3)*($C$4:$C$22<=$G$4)),INDEX($C:$C,SMALL(IF(($C$4:$C$22>=$G$3)*($C$4:$C$22<=$G$4),ROW($C$4:$C$22)),ROWS($4:4))),"")

In the 'J4' cell the formula below

=IFERROR(VLOOKUP(I4,$C$4:$D$26,2,FALSE),"")

 

[kumara_faith]

Hi Navic,

That worked. Thank you for your valuable time and patience. Appreciate it and have a great day.

 

[Fluff]

Another option

+Fluff 1.xlsm
	C	D	E	F	G	H	I	J
1
2	Table 1			Table 2			Table 3
3	Date	Price		Start Date	07/06/2012		Date	Price
4	02/11/2010	1.405625		End Date	13/02/2013		07/06/2012	1.9125
5	03/11/2010	1.425938					08/06/2012	1.96875
6	04/11/2010	1.476458					11/06/2012	1.874583
7	05/11/2010	1.478229					12/06/2012	1.93375
8	07/10/2011	1.336042					13/06/2012	1.895833
9	10/10/2011	1.473125					06/02/2013	2.354167
10	11/10/2011	1.504583					07/02/2013	2.36
11	07/06/2012	1.9125					08/02/2013	2.431667
12	08/06/2012	1.96875					11/02/2013	2.430833
13	11/06/2012	1.874583					12/02/2013	2.4025
14	12/06/2012	1.93375					13/02/2013	2.430417
15	13/06/2012	1.895833
16	06/02/2013	2.354167
17	07/02/2013	2.36
18	08/02/2013	2.431667
19	11/02/2013	2.430833
20	12/02/2013	2.4025
21	13/02/2013	2.430417
22	14/02/2013	2.425417
23	15/02/2013	2.404583
24	19/02/2013	2.457083
25	20/02/2013	2.345
26	21/02/2013	2.26875
Main

Cell Formulas
Range	Formula
I4:J14	I4	=FILTER(C4:D26,(C4:C26>=G3)*(C4:C26<=G4))
Dynamic array formulas.

 

[kumara_faith]

Hi Fluff,

Thank you for your solution. It worked as well. Appreciate your time and valuable input. Have a great day.

 

[Fluff]

Glad we could help & thanks for the feedback.