VLOOKUP can work if you test for no match and action accordingly

=IF(ISNA(lookup_formula),"",lookup_formula)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Rook" wrote in message
...
I have 12 cycles based on date range - Cycle 1: July 3 - Aug 3, Cycle 2:
Aug
4 - Sep 7,..., Cycle 12: June 25 - June 29. The cycle does not have a
fixed
no of days.

Help me how to program it such everytime I click a button, Excel will tag
the corresponding cycle.

Vlookup does not work since there are days not present in my cycles. I
don't
want to list down all 365 days and assign cycle no because it defeats the
whole purpose of programming.

Thanks