The value you are looking for in the array 'ROCKY POINT REVENUE'!I42:I1234
is the text string
"'ROCKY POINT REVENUE'!1/10/2007:15/10/2007".
It's a text string because you've enclosed it in quotes.

You may need to be clearer about exactly what you are trying to achieve. Do
you have dates in column I? What do you want to do when those dates fall
between 1st & 15th of Oct?
--
David Biddulph

"KeK23" wrote in message
...
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????