Lookup a date between other dates
 

Thanks for your everyone's help.
I ended up making a another tab with the dates start and end to get the
dates that I needed.
SEARCH NUMBER START END
138377 1 25-Jan-05 15-Feb-05


=IF(ISBLANK(C4),"",IF(AND(A4=LOOKUP(CONCATENATE(C 4&A4),CYCLE!A:C),A4<LOOKUP(CONCATENATE(C4&A4),CYCL E!A:D)),LOOKUP(CONCATENATE(C4&A4),CYCLE!A:C),""))


--
spalmarez
------------------------------------------------------------------------
spalmarez's Profile: http://www.excelforum.com/member.php...o&userid=15961
View this thread: http://www.excelforum.com/showthread...hreadid=274366

"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.