Hi All,

I'm using vba to enter the following code into some cells programatically:
Range(strHlookupCell).Value = "=HLOOKUP(A3,TCtl_DateRange,1,TRUE)".
where strHlookupCell = Sheet "PData" Range N3;
and TCtl_DataRange = Sheets "Control" Range B5:BA5

TCtl_DataRange is a listing of dates incrementing by 1 week.
What i need to be able to do, is look at cell A3 which is a date, and lookup
the TCtl_DataRange and find the next highest match. Not all values in A3 will
match perfectly to a value in TClt_DataRange.

Is there a way to lookup the value in A3 and return either an exact match,
or return the next highest value?

The code im using returns the closest value, not the next highest value.

Thanks.

Tones.