Lookup a date between other dates

[spalmarez]

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


=IF(ISBLANK(C4),"",IF(AND(A4>=LOOKUP(CONCATENATE(C4&A4),CYCLE!A:C),A4<LOOKUP(CONCATENATE(C4&A4),CYCLE!A)),LOOKUP(CONCATENATE(C4&A4),CYCLE!A:C),"")

 

[Harlan Grove]

=IF(ISBLANK(C4),"",IF(AND(A4>=LOOKUP(CONCATENATE(C4&A4),CYCLE!A:C),
A4<LOOKUP(CONCATENATE(C4&A4),CYCLE!A)),LOOKUP(CONCATENATE(C4&A4),
CYCLE!A:C),""))

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