Lookup Not Exact Match

[GB]

Hi,

I have in column A a series of dates (ascending). In Column B I have values. eg


Date Value

01Mar12 6.75

07Mar12 7.00

14Mar12 9.34


I want to do a lookup on a date to find its corresponding value, eg what is the value for date 10Mar12? If this date doesn't exist in the table then I want to return the value from the date listed before the 10Mar12, which will be 07Mar12 and the value to be returned will be 7.00. How can I do this?


thanks

GB

 

[NARAYANK991]

Hi ,


Use the LOOKUP function :


=LOOKUP(lookup_date,dates_range,values_range)


where :


lookup_date is the date you wish to look up , say 10-Mar-2012


dates_range is say A2:A24


values_range is say B2:B24


Narayan

 

[GB]

Thanks Narayan, that works perfectly.

cheers

GB