Hlookup Formula to Find a Date

[PaulFogel123]

I'm using HLookup formulas to find dates between two tables. My lookup dates are from a report table to be filled in from a database in the table array, below. :


If the dates match, no problem. The issue is that I want to capture the value (100) for Jan. 2014 even if cell A6 is entered as 1/15/14, and even if cell A3 is 1/16/14 (I don't care about the day, only the month and year). There will be only one value for each month in Table Array.

I would really appreciate a solution! Thanks.

 

[Haseeb A]

Hello Paul,

Just remove ,FALSE (comma FALSE) from your original formula. So this way will look for approximate match,NOT exact.

 

[PaulFogel123]

Hello Paul,

Just remove ,FALSE (comma FALSE) from your original formula. So this way will look for approximate match,NOT exact.

I removed ,FALSE and changed the date in cell A6 to 1/2/14. The result is #N/A.

 

[NARAYANK991]

Hi Paul ,

In the formula :

=HLOOKUP(A3,A6:C7,2,TRUE)

The first value in A6 should be the least value ; if A3 is less than A6 , then the HLOOKUP will return #N/A.

Ensure that A6 is the lowest possible value , and use the above formula.

Narayan

 

[PaulFogel123]

Hello Haseeb and Narayank991,

Although I do not have control over the exact date in A6, I do have control over the date in A3. By using the EOMONTH function in A3, I can ensure that it will always be equal to or higher than whatever date for the same month is entered into A6.

Thank you so much for sharing your help and expertise.
Paul