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

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

If no formula in the cell, no result can be returned to that cell without
using VBA

Formulas "pull" and cannot "push"


Gord Dibben MS Excel MVP


On Wed, 26 Nov 2008 16:42:03 -0800, 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

Thanks Gord. Thought that might have been the case.
Thanks for your response Pete_UK (sorry about the wrong referencing, changed
it at the last minute)

"Gord Dibben" wrote:

If no formula in the cell, no result can be returned to that cell without
using VBA

Formulas "pull" and cannot "push"


Gord Dibben MS Excel MVP


On Wed, 26 Nov 2008 16:42:03 -0800, 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

You're welcome.

Pete

On Nov 27, 4:51*am, Damien wrote:
Thanks Gord. Thought that might have been the case.
Thanks for your response Pete_UK (sorry about the wrong referencing, changed
it at the last minute)