change values in a column

[dmack]

i am looking for a way to be able to drag the information in a cell down a
column keeping some information constant while changing others. For example:
=IF($B$2=4,"4",IF($C$2=4,"4"))
=IF($B$2=5,"5",IF($C$2=5,"5"))
I would like to be able to have the following cells continue with the number
sequence
=IF($B$2=6,"6",IF($C$2=6,"6"))
=IF($B$2=7,"7",IF($C$2=7,"7")) etc.
thx

 

[Pete_UK]

Try it like this:

=IF($B$2=ROW(A4),""&ROW(A4),IF($C$2=ROW(A4),""&ROW(A4)))

and copy it down. You do not specify what to do if neither B2 nor C2 =
4 (in your first formula).

Hope this helps.

Pete

 

[Don Guillett]

=IF($B$4=ROW(A6),6,400)
or
=IF(OR($B$4=ROW(a6),$C$4=ROW(a6)),6,900)

 

[Max]

Try this in the starting cell, say in D2:
=IF($B$2=ROWS($1:1)+2,ROWS($1:1)+2,IF($C$2=ROWS($1:1)+2,ROWS($1:1)+2,""))
Copy down