Posted to microsoft.public.excel.misc

external usenet poster

Posts: 20

LOOKUP FORMULA

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????

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
LOOKUP formula	Snake_Plisken[_2_]	Excel Worksheet Functions	2	August 5th 07 12:01 AM
Lookup formula	Rowland	Excel Worksheet Functions	2	February 1st 07 03:29 PM
Lookup Formula Help - PLEASE!	VickyC	Excel Worksheet Functions	4	February 28th 06 12:09 PM
Max Lookup formula	sam	Excel Worksheet Functions	5	September 16th 05 06:55 AM
Lookup Formula - but have a formula if it can't find/match a value	Stephen	Excel Worksheet Functions	11	June 14th 05 05:32 AM

All times are GMT +1. The time now is 11:48 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us