Get values based on intervals with dates

[sanyo1234]

HI all,

I have a set up with base values on one sheet
01/12/2011 8.6
01/04/2012 8.8
01/04/2013 8.7
01/04/2016 8.1
01/10/2016 8.0
01/04/2017 7.9
01/07/2017 7.8
01/01/2018 7.6

Now if the month in a cell (on another sheet)is april-14 the result must be 8.7 and for may-17 is 7.9 Likewise for any kind of input on other sheets the result should be based on master sheet(SET UP)

i have tried out index match functions but i am getting errors is there any way out for getting the desired result
Thanking you
[TABLE="width: 139"]
<tbody>[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

 

[markmzz]

HI all,

I have a set up with base values on one sheet
01/12/2011 8.6
01/04/2012 8.8
01/04/2013 8.7
01/04/2016 8.1
01/10/2016 8.0
01/04/2017 7.9
01/07/2017 7.8
01/01/2018 7.6

Now if the month in a cell (on another sheet)is april-14 the result must be 8.7 and for may-17 is 7.9 Likewise for any kind of input on other sheets the result should be based on master sheet(SET UP)

i have tried out index match functions but i am getting errors is there any way out for getting the desired result
Thanking you

Try this in E2 and copy down:

=LOOKUP(D2,$A$2:$B$9)


[TABLE="class: grid, width: 329"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date Range[/TD]
[TD]Value[/TD]
[TD][/TD]
[TD]Date[/TD]
[TD]Value[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]01/12/2011[/TD]
[TD]8,6[/TD]
[TD][/TD]
[TD]abr-14[/TD]
[TD]8,7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]01/04/2012[/TD]
[TD]8,8[/TD]
[TD][/TD]
[TD]mai-17[/TD]
[TD]7,9[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]01/04/2013[/TD]
[TD]8,7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]01/04/2016[/TD]
[TD]8,1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]01/10/2016[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]01/04/2017[/TD]
[TD]7,9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]01/07/2017[/TD]
[TD]7,8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]01/01/2018[/TD]
[TD]7,6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]***[/TD]
[TD]**********[/TD]
[TD]*******[/TD]
[TD]**[/TD]
[TD]**********[/TD]
[TD]******[/TD]
[TD]**[/TD]
[/TR]
</tbody>[/TABLE]

Markmzz

 

[sanyo1234]

Its really wondering and its that simple !!

thank you very much Markmzz unbelievable

 

[markmzz]

Its really wondering and its that simple !!

thank you very much Markmzz unbelievable

You are welcome and thanks for the return.

Markmzz