This is my formula, it is returning a #VALUE error. I am trying to calculate
information in colum I if it falls between the first of the month and 15th of
the month.

=LOOKUP("'ROCKY POINT REVENUE'!1/10/2007:15/10/2007",'ROCKY POINT
REVENUE'!I42:I1234)

Can anyone help????