I have a spreadsheet of dates and values that I need to perform a lookup on. Here is my data structure:
Column B - dates in Ascending order
Column J - numeric values
My problem is that I can't perform a standard lookup where I have a known value in column b that will return a value from column j. The lookups that I need to perform are based on calendar years. So for example, in the attached spreadsheet if I were doing my lookup for 2013 value I need returned is $35,904.58, if I were doing my lookup for 2014 the value I need returned is $34,589.33.
So what I need is a formula that will look for the maximum date in column b for a given year, and then return the value in the corresponding position in column j.