=IF(ISNUMBER(MATCH(B$1,A$1:A$100,0)),OFFSET(A1,MAT CH(B$1,A$1:A$100),0),"")
and copy down 2 more rows,
if you've put your number in B1.
--
David Biddulph


"nathan" wrote in message
...
I want to be able to enter a number in a cell and a formula search for that
number in column A only, and then copy the three cells next to that cell
down
next to that number. Can office 2007 do this? Please help!!!