If I put FALSE in the formula I get #N/A as the value in the HLookup cells.
The values I am looking up are monetary values.

The dates are not text but are formated as dates (MAR-01).

Thank you....Any other thoughts?
--
searcherlady


"Peo Sjoblom" wrote:

Are you looking for an exact match then you should replace TRUE with FALSE,
if not the lookup column needs to be sorted in ascending order
Also check that the dates are not text


--
Regards,

Peo Sjoblom



"searcherlady" wrote in message
...
Using TODAY() rather than NOW() had not affect on the results.
--
searcherlady


"Bernard Liengme" wrote:

Try using TODAY() rather than NOW() and tell us if this works
You seem to want only the date not date+time
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"searcherlady" wrote in message
...
If today's date is June 7, 2007 and formula in B4 on Monthly Expense
spreadsheet is =Now()-33 (to Sat May 5, 2007) the HLookup formula in
column
D, rows 5 - 24, of the CPH Master spreadsheet does not work (pulls in
data
from wrong column). However, if the formula in B4 on the Monthly
Expense
is
=Now()-32 (to Sun, May 6, 2007) the HLookup formula in Column D, rows
5 -
24,
of the CPH Master does work.

Example formula in row 5 of the CPH Master is: =HLOOKUP('Monthly
Expense'!$B$4,'Monthly Expense'!$C$4:$P$22,3,TRUE)*'CPH Master'!$B$28

If today's date is June 8, 2007 and formula in B4 on Monthly Expense
spreadsheet is =Now()-34 (to Sat May 5, 2007) the HLookup formula in
column
D, rows 5 - 24, of the CPH Master spreadsheet does not work (again,
pulls
in
data from wrong column in look up table). However, if the formula in
B4
on
the Monthly Expense is =Now()-33 (to Sun, May 6, 2007) the HLookup
formula
in
Column D, rows 5 - 24, of the CPH Master does work.

This report has run for a couple of months for a variety of sites (all
using
the same template) and this is the first time this problem was noticed.
It
appears to have something to do with the dates and not the formula.
The
effectiveness of the formula in both described incidents changes with
the
date, not the formula.

Any ideas?

--
searcherlady