Lookup a date between other dates

Harlan Grove

Posts: n/a

"spalmarez" wrote...
....
=IF(ISBLANK(C4),"",IF(AND(A4=LOOKUP(CONCATENATE( C4&A4),CYCLE!A:C),
A4<LOOKUP(CONCATENATE(C4&A4),CYCLE!A:D)),LOOKUP(C ONCATENATE(C4&A4),
CYCLE!A:C),""))

No! Don't use CONCATENATE(C4&A4). Just use C4&A4.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Excel: How do I enter a date in one cell & automatically dates adj	Shannon	Excel Discussion (Misc queries)	4	January 12th 05 12:51 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
Lookup the latest date in a range so it appears as my result	FBB	Excel Discussion (Misc queries)	1	December 4th 04 03:50 AM
How can I hide points for future dates on a Year to Date chart?	rlmills	Charts and Charting in Excel	1	November 29th 04 05:23 PM
Lookup a date between other dates	spalmarez	Excel Worksheet Functions	4	November 2nd 04 09:06 AM

All times are GMT +1. The time now is 12:44 AM.

Menu

About Us