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