View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tywlam tywlam is offline
external usenet poster
 
Posts: 22
Default hlookup value within a range

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!