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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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