Using lookup and date ranges

[DrH100]

Hopefully this is quite a simple one

In Cell A1 i have a date

in cells d1 :e10 I have a table of date ranges and in f1:f10 I have a number
eg

What I would like is a formula to find which range the date in A1 falls within and then return the number that corresponds in column F. I would be putting this in B1

In the example i've been using (table below) I have used month start and end dates but in the real version the range may not be whole months or may be longer than a month.

Any help appreciated

[TABLE="width: 154"]
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;" span="2" width="71"> <col style="width: 48pt;" width="64"> <tbody>[TR]
[TD="class: xl67, width: 71, bgcolor: #CCFFFF"]d[/TD]
[TD="class: xl67, width: 71, bgcolor: #CCFFFF"]e[/TD]
[TD="class: xl69, width: 64, bgcolor: #CCFFFF"]f[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/03/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]31/03/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]1[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/04/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]30/04/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]2[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/05/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]31/05/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]3[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/06/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]30/06/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]4[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/07/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]31/07/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]5[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/08/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]31/08/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]6[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/09/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]30/09/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]7[/TD]
[/TR]
[TR]
[TD="class: xl71, bgcolor: #FFFF99"]01/10/2014[/TD]
[TD="class: xl71, bgcolor: #FFFF99"]31/10/2014[/TD]
[TD="class: xl72, bgcolor: #FFFF99"]8[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Try in B1

=VLOOKUP(A1,D1:F10,3,1)

 

[DrH100]

Thanks Peter

Works perfectly

 

[Peter_SSs]

Thanks Peter

Works perfectly

Glad to help. Thanks for letting us know.