Populating adjacent cells

[Damien]

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

 

[Pete_UK]

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

 

[Gord Dibben]

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

 

[Damien]

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)

 

[Pete_UK]

You're welcome.

Pete