I want the ability to enter a date into A2 then using a formula in C2 lookup
the date in row 3. Upon finding the date I want a cell in row 5 directly
below the matched date in row 3 to show text "Start".

I know this is possible with a macro to enter text into a specific cell but
I wanted to know if there is a formula that allows for the offsetting of a
result when no formula is entered into the cell to show "Start"? I kinda need
offset to reverse.

A B C D E F
1 Start Date: 4-1-08 =OFFSET(A3,2,MATCH(B2,$A$3:$F$3,0))...
2
3 3-30-08 3-31-08 4-1-08 4-2-08 4-3-08 4-5-08
4
5 Start