You are showing the date entered into B1, not A2, but you can use this
formula in A5:

=IF(A3=$B$1,"Start","")

Change $B$1 to $A$2 if that is the cell you want to put the date in,
and then copy the formula across the row as far as you need to - no
need for anything in C2 (or C1 as you have shown it).

Hope this helps.

Pete

On Nov 27, 12:42*am, Damien wrote:
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