Actually I wanted to work within the ranges of dates, i.e if the date falls within 01/07/2010 - 30/06/2011 if the value in B column is 0.3 and date is 29/06/2011 or 02/07/2010 then it should bring 0.3, which I achieved through extending the dates ranges in lookup formula itself. But if there is any simple way to do that, kindly let me know as some time date ranges are many and individual date would be difficult.

Hope I have clarified this now.

Thanks