Data Extraction

[Gusher]

Hi

In Column A I have daily dates , in column B i have values. In Column C I have month end dates. In Column D i need a formula that for any given month end date in column C will return the LAST available value (Column B) for that month from the dates in column A. So for example if 29th June 2000 is the last date form June 2000 in column A the data in Colmn B for that date will be returned.

 

[Peter_SSs]

Is this what you mean? If not more specific detail and/or examples would help

Excel Workbook
	A	B	C	D	E
1	Daily	Value	Month End	Value	Month End
2	25/06/2019	1	30/06/2019	5	30/06/2019
3	26/06/2019	2	30/06/2019	12	31/07/2019
4	27/06/2019	3	30/06/2019
5	28/06/2019	4	30/06/2019
6	29/06/2019	5	30/06/2019
7	1/07/2019	6	31/07/2019
8	2/07/2019	7	31/07/2019
9	3/07/2019	8	31/07/2019
10	4/07/2019	9	31/07/2019
11	5/07/2019	10	31/07/2019
12	6/07/2019	11	31/07/2019
13	7/07/2019	12	31/07/2019
14
Last of month

 

[DanteAmor]

Another option.
You can get the end of the month dates, day and value with a pivot table.

 

[Peter_SSs]

.. also, if you only have the end-of-month dates in column C for this purpose and your 'daily dates' are in chronological order, you don't need column C.

Excel Workbook
	A	B	C	D	E
1	Daily	Value		Value	Month End
2	25/06/2019	1		5	30/06/2019
3	26/06/2019	2		12	31/07/2019
4	27/06/2019	3
5	28/06/2019	4
6	29/06/2019	5
7	1/07/2019	6
8	2/07/2019	7
9	3/07/2019	8
10	4/07/2019	9
11	5/07/2019	10
12	6/07/2019	11
13	7/07/2019	12
14
Last of month (2)