Use MATCH to return the row and then use index to return the entry. Try this

A1: A12 is the month Jan 09, Feb 09, Mar 09....Dec 09
A15 = 4/5/2009

=MATCH(MONTH(A15),MONTH(A1:A12),0)

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in the Formula Bar you can notice the curly braces at both ends
"{=<formula}"

If this post helps click Yes
---------------
Jacob Skaria


"tywlam" wrote:

How do I look up a value that falls within a range by hlookup function? I
want to lookup a date that matchs the same month in the target range and
return the value from the same row. For examples:

4/5/2009 to match May 2009 or
4/5/2009 to match 1/5/2009

Thanks!