Populating adjacent cells

  • Thread starter Thread starter Damien
  • Start date Start date
D

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
 
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
 
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
 
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)
 
Back
Top