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

On Apr 21, 10:25*pm, dmack wrote:
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

--
thanx